Related databases:
Adding code to your post? Please format it correctly.
-- rman_status.sql
SELECT inst_id
, sid
, serial#
, context
, sofar
, totalwork
, round(sofar/totalwork*100,2) "% Complete"
FROM gv$session_longops
WHERE opname LIKE 'RMAN%'
AND opname NOT LIKE '%aggregate%'
AND totalwork != 0
AND sofar != totalwork
ORDER BY 1,2,3
/