How to find if the export job is running or Hanging
SET PAUSE ON
SET PAUSE 'Press Return to Continue'
SET PAGESIZE 60
SET LINESIZE 300
col MODULE for a30
col EVENT for a50
col SQL_ID for a15
col STATUS for a10
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
/
SET PAUSE 'Press Return to Continue'
SET PAGESIZE 60
SET LINESIZE 300
col MODULE for a30
col EVENT for a50
col SQL_ID for a15
col STATUS for a10
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
/
Observe the BLOCK_CHANGES column if the value keeps increasing , your job is running and not hanging
Comments
Post a Comment