Troubleshooting datapump issues
How To Cleanup Orphaned DataPump Jobs In DBA_DATAPUMP_JOBS ? (Doc ID 336014.1) Data Pump Recommended Proactive Patches For 19.10 and Above (Doc ID 2819284.1) 2) SRDC - Diagnostic Collection for DataPump Export Performance Issues (Doc ID 1935743.1) i) provide full expdp command and expdp.log ii) At the point of slow or hang Enable the event 10046 level 12 tracing for the DataPump Master (DM) and Worker (DW) processes (for versions >= 11g): SQL> connect / as sysdba -- Versions >= 11g and < 12c SQL> alter system set events 'sql_trace {process : pname = dw | pname = dm} level=12'; -- Version = 12c or higher SQL> alter system set events 'sql_trace {process: pname = dw | process: pname = dm} level=12'; Then start expdp with parameter EXCLUDE=STATISTICS METRICS=Y TRACE=480301 added to command line. To disable the tracing perform: SQL> connect / as sysdba -- Versions >= 11g and < 12c SQL> alter system set events 'sql_trace {process : pname = d...