So you are running an impdp job and would like to monitor the progress,running this sql statement does the trick SQL>select t.username,t.TIME_REMAINING,t.ELAPSED_SECONDS,t.opname,t.target_desc,t.sofar,t.totalwork,t.message from V$SESSION_LONGOPS t where t.TIME_REMAINING !=0 ; USERNAME TIME_REMAINING ELAPSED_SECONDS ------------------------------ -------------- --------------- OPNAME ---------------------------------------------------------------- TARGET_DESC SOFAR TOTALWORK -------------------------------- ---------- ---------- MESSAGE -------------------------------------------------------------------------------- SYSTEM ...