Raunak's DBA Blog

 SELECT      inst_id,     SID,      SERIAL#,      OPNAME,      SOFAR,      TOTALWORK,      ROUND(SOFAR/TOTALWORK*100, 2) AS "%_COMPLETE",      START_TIME  FROM      GV$SESSION_LONGOPS  WHERE      OPNAME LIKE 'EXPORT%'      AND TOTALWORK > 0;

 SELECT      sl.inst_id,     sl.sid,     sl.serial#,     s.username,     sl.opname AS operation,     sl.sofar,     sl.totalwork,     ROUND(sl.sofar / sl.totalwork * 100, 2) AS pct_done,     sl.start_time,     sl.last_update_time,     sl.elapsed_seconds,     sl.time_remaining,     s.program FROM      gv$session_longops sl JOIN      gv$session s ON sl.sid = s.sid AND sl.inst_id = s.inst_id WHERE      sl.opname LIKE 'SYS_EXPORT%'      AND sl.totalwork > 0      AND sl.sofar <= sl.totalwork ORDER BY pct_done DESC;