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;
  • September 6, 2015 | 9 views
  • Comments