How to trace a data pump process


1)  Run the normal export data pump or you can prepare a parfile something like this..

FULL=Y
DUMPFILE=EXPDP_DUMPDIR:expdp_MYDB_ROWS_FULL%U_012413:1800.dmp
CLUSTER=N
LOGFILE=EXPDP_LOGDIR:expdp_MYDB_ROWS_FULL_012413:1800.log
PARALLEL=4
CONTENT=ALL

2. Connect to sqlplus AS SYSDBA user and obtain Data Pump process information:

 set lines 150 pages 100 numwidth 7
set time on
 col program for a38
 col username for a10
 col spid for a7
 select to_char(sysdate,'YYYY-MM-DD HH24:MI:SS') "DATE", 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;

3. From the same sqlplus session and using the information from the above step, attach to the Datapump Worker (DW01) process:

SQL> oradebug setospid <spid_of_dw_process>

4. Run the following command every few minutes

SQL> oradebug current sql

There are master process trace and worker process trace.

No comments:

Post a Comment