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;