DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Sunday, September 6, 2015

Monitoring the Datapump jobs


Monitoring the Datapump jobs





set lines 150 pages 100 numwidth 7col program for a38col username for a10col spid for a7select 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,s.eventfrom v$session s, v$process p, dba_datapump_sessions dwhere p.addr=s.paddr and s.saddr=d.saddr; 




select
   round(sofar/totalwork*100,2)  percent_completed,
   v$session_longops.*
from
   v$session_longops
where
   sofar <> totalwork
order by
   target,
   sid; 




select x.job_name,b.state,b.job_mode,b.degree, x.owner_name,z.sql_text, p.message, p.totalwork, p.sofar, round((p.sofar/p.totalwork)*100,2) done, p.time_remainingfrom dba_datapump_jobs b left join dba_datapump_sessions x on (x.job_name = b.job_name)left join v$session y on (y.saddr = x.saddr)left join v$sql z on (y.sql_id = z.sql_id)left join v$session_longops p ON (p.sql_id = y.sql_id)WHERE y.module='Data Pump Worker'AND p.time_remaining > 0;

No comments: