Hi all,

You can find status of impdp that executing with these queries:

#1
SELECT * 
FROM DBA_DATAPUMP_JOBS 
WHERE STATE = 'EXECUTING';

#2
SELECT SID, SERIAL#, SOFAR, TOTALWORK, DP.OWNER_NAME, DP.STATE, DP.JOB_MODE 
FROM GV$SESSION_LONGOPS SL, GV$DATAPUMP_JOB DP 
WHERE SL.OPNAME = DP.JOB_NAME AND SOFAR != TOTALWORK;

#3
SELECT SID, SERIAL#, OPNAME, SOFAR, TOTALWORK, ROUND(SOFAR/TOTALWORK*100,2) COMPLETE 
FROM V$SESSION_LONGOPS 
WHERE TOTALWORK != 0 AND SOFAR != TOTALWORK 
ORDER BY 1;

#4
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_REMAINING
FROM 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;

See you later.

Oracle

DATA PUMPIMPDP