Monitoring RMAN Job Progress

From NazimWIKI
Jump to navigation Jump to search
SELECT sid
     , serial#
     , context
     , sofar
     , totalwork
     , round(sofar/totalwork*100,2) "%_Complete"
  FROM v$session_longops
 WHERE opname like 'RMAN%'
   AND opname not like '%aggregate%'
   AND totalwork != 0
   AND sofar <> TOTALWORK;