--

-- Check to see if a data Pump Job is Hung

--

SET PAUSE ON

SET PAUSE 'Press Return to Continue'

SET PAGESIZE 60

SET LINESIZE 300

SELECT 

  v.status, 

  v.SID,

  v.serial#,

  io.block_changes,

  event, module,

  v.sql_id 

FROM 

  v$sess_io io,

  v$session v 

WHERE 

  io.SID=v.SID 

AND 

  v.saddr IN (SELECT saddr FROM dba_datapump_sessions) 

ORDER BY 

  io.BLOCK_CHANGES

/

Notes

If Block changes are going up, then the Data Pump Job is Not Hung

If the Data Pump Job is Suspended, then an Event will be returned detailing this.