译：Data Pump New Diagnostic V$ Views For Performance Issues in 23c (Doc ID 2920029.1)
适用：
Oracle Database - Enterprise Edition - Version Beta 23c and laterInformation in this document applies to any platform.
目的：
本文介绍在23c中用于Data Pump的新的DataPump (G)v$视图以及推荐使用。
范围：
本文的目标是为expdp和impdp提供一个数据收集方法论，以便诊断Oracle 23c中的Job性能问题。
细节：
在23c中，如下三个新视图被建立有助于更快的诊断Data Pump性能相关问题。
(G)V$DATAPUMP_PROCESS_INFO
(G)V$DATAPUMP_PROCESSWAIT_INFO
(G)V$DATAPUMP_SESSIONWAIT_INFO
(G)V$DATAPUMP_PROCESS_INFO
描述：获得Data Pump进程信息
代码语言：javascript复制SQL> desc gv$datapump_process_info;Name Null? Type---------------------------INST_ID NUMBERCUR_DATE VARCHAR2(19)PROGRAM VARCHAR2(84)SESSIONID NUMBERSTATUS VARCHAR2(8)USERNAME VARCHAR2(128)JOBNAME VARCHAR2(128)SPID VARCHAR2(24)SERIALNUMBER NUMBERPROCESSID NUMBERCON_ID NUMBER样例输出：
代码语言：javascript复制select * from v$datapump_process_info;CUR_DATE PROGRAM SESSIONID STATUS USERNAME JOBNAME SPID SERIALNUMBER PROCESSID CON_ID------------------- -------------------------------------- --------- -------- ---------- ------------------2023-01-09 13:56:07 ude@orcl (TNS V1-V3) 42 ACTIVE SYSTEM SYS_EXPORT_FULL_01 3891480 11829 70 02023-01-09 13:56:07 oracle@orcl (DW00) 48 ACTIVE SYSTEM SYS_EXPORT_FULL_01 3891500 36244 82 02023-01-09 13:56:07 oracle@orcl (DM00) 149 ACTIVE SYSTEM SYS_EXPORT_FULL_01 3891494 42966 79 0(G)V$DATAPUMP_PROCESSWAIT_INFO
描述：获得Data Pump进程等待信息
代码语言：javascript复制SQL> desc gv$datapump_processwait_info; Name Null? Type-------------------------------------INST_ID NUMBERWAITING_SESSION NUMBERHOLDING_SESSION NUMBERSERIAL_NUMBER NUMBEREVENT VARCHAR2(64)PROGRAM_WAITSESSION VARCHAR2(84)PROGRAM_HOLDINGDSESSION VARCHAR2(84)MODULE_WAITSESSION VARCHAR2(64)MODULE_HOLDINGSESSION VARCHAR2(64)DATAPUMP_LOCKID NUMBERCON_ID NUMBER样例输出：
代码语言：javascript复制SQL> select * from gv$datapump_processwait_info;INST_ID WAITING_SESSION HOLDING_SESSION SERIAL_NUMBER EVENT PROGRAM_WAITSESSION PROGRAM_HOLDINGDSESSION MODULE_WAITSESSION MODULE_HOLDINGSESSION DATAPUMP_LOCKID CON_ID------------------------------------------------------------------------------------------------------------------------------------------------------------- 1 174 57 40525 enq: TM - contention oracle@orcl (DM00) oracle@orcl (DW00) Data Pump Master Data Pump Worker 79473 1(G)V$DATAPUMP_SESSIONWAIT_INFO
描述：获得Data Pump进程等待信息
代码语言：javascript复制SQL> desc gv$datapump_sessionwait_info;Name Null? Type------------------------------------INST_ID NUMBERWAITING_SESSION NUMBERSERIAL_NUMBER NUMBERSEQ_NUMBER NUMBEREVENT VARCHAR2(64)DP_WAITTIME NUMBERDP_SECONDS_IN_WAIT NUMBERDP_STATE_IN_WAIT VARCHAR2(19)DP_P1TEXT VARCHAR2(64)DP_P1 NUMBERDP_P2TEXT VARCHAR2(64)DP_P2 NUMBERDP_P3TEXT VARCHAR2(64)DP_P3 NUMBERCON_ID NUMBER样例输出
代码语言：javascript复制SQL> select * from gv$datapump_sessionwait_info;INST_ID WAITING_SESSION SERIAL_NUMBER SEQ_NUMBER EVENT DP_WAITTIME DP_SECONDS_IN_WAIT DP_STATE_IN_WAIT DP_P1TEXT DP_P1 DP_P2TEXT DP_P2 DP_P3TEXT DP_P3 CON_ID--------------------------------------------------------------------------------------------------------------------------------------------1 46 65244 1319 enq: TM - contention 0 8086 WAITING name|mode 1414332419 object # 80996 table/partition 0
