Monitoring RMAN Job Progress
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;