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;