Can you confirm if the same data was exported quickly before? If so can we know the time difference?
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
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