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.