trace the expdp log（跟踪EXPDP日志）

来源：互联网发布：python数据可视化编程编辑：程序博客网时间：2024/06/05 07:18

Perform the following and provide the trace files generated:

Ensure there is sufficient space in the udump destination.
Execute the export session.
The following query will give us the sid, serial# and pid of the export session:

set lines 150 pages 100 numwidth 7
col program for a38
col username for a10
col spid for a7
SQL>select s.program, s.sid,
s.status, s.username, d.job_name, p.spid, s.serial#, p.pid
from v$session s, v$process p, dba_datapump_sessions d
where p.addr=s.paddr and s.saddr=d.saddr;

To SQL_TRACE Master Control process with level 8 (Waits):
execute sys.dbms_system.set_ev(sid,serial#,10046,8,''); ---------> enter the export session sid, serial# from the above query. Do this for both the master process and the worker process.
Wait for 20 mins and then disable the trace
To disable:
execute sys.dbms_system.set_ev(sid,serial#,10046,0,'');

-- This results in two trace files in BACKGROUND_DUMP_DEST:
-- Master Process trace file: <SID>_dm<number>_<process_id>.trc
-- Worker Process trace file: <SID>_dw<number>_<process_id>.trc

0 0