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 113 6796 SYS_IMPORT_FULL_01 IMPORT 35963 36559 SYS_IMPORT_FULL_01: IMPORT : 35963 out of 36559 MB done SQL>