Monitoring RMAN Job Progress

From NazimWIKI
Revision as of 23:33, 8 November 2019 by Admin (talk | contribs) (Created page with "<blockquote><pre> SELECT sid , serial# , context , sofar , totalwork , round(sofar/totalwork*100,2) "%_Complete" FROM v$session_longops WHERE opnam...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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;