Oracle Uzun Süren İşlemlerin İlerlemesi (v$session_longops)

SELECT sid, serial#, username, opname, target,
       sofar, totalwork,
       ROUND(100 * sofar / NULLIF(totalwork, 0), 1) AS pct_done,
       ROUND(elapsed_seconds / 60, 1) AS elapsed_min,
       ROUND(time_remaining / 60, 1)  AS remaining_min,
       sql_id
FROM   v$session_longops
WHERE  totalwork > 0
  AND  sofar < totalwork
ORDER  BY time_remaining DESC;