Hi all,
You can find status of impdp that executing with these queries:
#1
SELECT
*
FROM
DBA_DATAPUMP_JOBS
WHERE
1 = 1 AND 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
1 = 1 AND 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
1 = 1 AND 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
1 = 1 AND Y.MODULE = 'Data Pump Worker' AND P.TIME_REMAINING > 0;
See you later.