Hi Experts,
IMPDP jos is not moving forward, how do we know is it running fine or getting problem ?
SQL> SELECT sl.sid, sl.serial#, sl.sofar, sl.totalwork, dp.owner_name, dp.state, dp.job_mode
FROM v$session_longops sl, v$datapump_job dp
WHERE sl.opname = dp.job_name
AND sl.sofar != sl.totalwork;
SID SERIAL# SOFAR TOTALWORK OWNER_NAME STATE JOB_MODE
---------- ---------- ---------- ---------- ------------ ---------------------- ----------------
986 29665 26473 26474 SYS EXECUTING FULL
Last 2 hours , I am seeing same output. sofar is not moving forward and not getting any error
DB : 12.2