SELECT
OPNAME,SID,SERIAL#,CONTEXT,SOFAR,TOTALWORK, ROUND(SOFAR/TOTALWORK*100,2) "PERCENTAGE_COMPLETE"
FROM V$SESSION_LONGOPS
WHERE OPNAME in
(
select d.job_name
from v$session s, v$process p, dba_datapump_sessions d
where p.addr=s.paddr and s.saddr=d.saddr
)
AND OPNAME NOT LIKE '%aggregate%'
AND TOTALWORK != 0
AND SOFAR <> TOTALWORK;
No comments:
Post a Comment