Check the progress of IMPDP and EXPDP Datapump jobs

Check the datapump jobs with dba_datapump_jobs view

set line 200 page 200
col owner_name format a12
col job_name format a20
col operation format a12
col job_mode format a20
SELECT 
owner_name, job_name, operation, job_mode, 
state FROM 
dba_datapump_jobs
where 
state='EXECUTING';

Check the datapump job status with longops view

SELECT OPNAME, SID, SERIAL#, CONTEXT, SOFAR, TOTALWORK,
    ROUND(SOFAR/TOTALWORK*100,2) "%_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;
This entry was posted in Oracle on by .
Unknown's avatar

About SandeepSingh

Hi, I am working in IT industry with having more than 15 year of experience, worked as an Oracle DBA with a Company and handling different databases like Oracle, SQL Server , DB2 etc Worked as a Development and Database Administrator.

Leave a Reply