set pages 10000
set lines 600

TTITLE LEFT '% Completed. Aggregate is the overall progress:'
SET LINE 132
SELECT opname, round(sofar/totalwork*100) "% Complete"
  FROM gv$session_longops
 WHERE opname LIKE '%IMPORT%' or opname LIKE '%EXPORT%'
   AND totalwork != 0
   AND sofar <> totalwork
 ORDER BY 1;

select owner_name, job_name, session_type 
from dba_datapump_sessions;

select v.status, v.sid,v.serial#,io.block_changes,event 
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 sid;


select s.sid, s.module, s.state, 
       substr(s.event, 1, 60) as event,
       s.seconds_in_wait as secs, 
       substr(sql.sql_text, 1, 60) as sql_text
from v$session s
join v$sql sql on sql.sql_id = s.sql_id
where s.module like 'Data Pump%'
order by s.module, s.sid;
 exit;

