Check if Data Pump Job is Hung
--
-- 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.

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License