Monitor the progress of oracle impdp datapump job

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>