datapump_info.sql

-- ************************************************************************************************************
-- * Filename           : datapump_info.sql
-- * Author             : Saravanakumar K
-- * Description        : This script with show progress of export/import  
-- * Usage              : @datapump_info.sql
-- * Version            : v1
-- *************************************************************************************************************
set lines 200 pages 9999
col "SID,SERIAL#,Username" for a25
col message for a75
col STATE for a15
col JOB_MODE for a12
col OPERATION for a12
SELECT
    s.sid
    || ','
    || s.serial#
    || ','
    || dp.owner_name "SID,SERIAL#,Username",
    sl.sofar,
    sl.totalwork,
    dp.state,
    dp.job_mode,
    dp.operation,
    sl.message
FROM
    gv$session           s,
    gv$session_longops   sl,
    dba_datapump_jobs   dp
WHERE
    s.sid = sl.sid
    AND s.serial# = sl.serial#
    AND s.username = dp.owner_name
    AND ( sl.time_remaining > 0
          OR sl.totalwork > 0 )
   and dp.state = 'EXECUTING';
clear col