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;

Popular posts from this blog