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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment