Monitoring RMAN Job Progress

Monitoring RMAN Job Progress

SQL>select sid, serial#, sofar, totalwork, opname,
2 round(sofar/totalwork*100,2) "% Complete"
3 from v$session_longops
4 where opname LIKE 'RMAN%'
5 and opname NOT LIKE '%aggregate%'
6 and totalwork != 0
7 and sofar <> totalwork;

SID SERIAL# SOFAR TOTALWORK OPNAME % Complete
---------- ---------- ---------- ---------- ---------------------------------------------------------------- ----------
2838 43105 902382 902956 RMAN: archived log backup 99,94


column event format a40
column username format a20
set linesize 200
set pagesize 20
SELECT inst_id, SID,EVENT, WAIT_TIME, SEQ#,STATE, seconds_in_wait, username, program FROM GV$SESSION
WHERE EVENT NOT IN ('VKRM Idle','lreg timer','heartbeat redo informer','AQPC idle','EMON slave idle wait','SQL*Net message from client', 'pmon timer','rdbms ipc message','virtual circuit next request','GCR sleep','JOX Jit Process Sleep',
'smon timer','slave wait','SQL*Net message to client','pipe get','gcs remote message','ges remote message','wakeup time manager','PX Deq: reap credit','PX Deq: Execute Reply','global cache cr request','jobq slave wait','ASM background timer','DIAG idle wait','class slave wait','jobq slave wait','PX Deq: Execution Msg','fbar timer','VKTM Logical Idle Wait','Space Manager: slave idle wait','PING','wait for unread message on broadcast channel','LNS ASYNC end of log',
'watchdog main loop','pman timer','gcs yield cpu','LGWR worker group idle','LGWR worker group idle','ASM cluster membership changes','Streams AQ: qmn slave idle wait','Data Guard: Gap Manager',
'Streams AQ: qmn coordinator idle wait','REPL Capture/Apply: RAC AQ qmn coordinator','watchdog main loop','OFS idle','watchdog main loop','SCM slave idle','Data Guard: Timer','Streams AQ: waiting for time management or cleanup tasks','watchdog main loop',
'pman timer','gcs yield cpu','ASM cluster membership changes','Data Guard: Timer','watchdog main loop','OFS idle','watchdog main loop','LGWR worker group idle','LGWR worker group idle','SCM slave idle','Data Guard: Gap Manager',
'REPL Capture/Apply: RAC AQ qmn coordinator','Streams AQ: waiting for time management or cleanup tasks','Streams AQ: qmn slave idle wait','Streams AQ: qmn coordinator idle wait','Data Guard: controlfile update','LNS ASYNC dest activation','parallel recovery slave next change','SQL*Net more data from client','MRP redo arrival','parallel recovery slave next change','parallel recovery slave next change','LMS CR slave timer','ASM IO for non-blocking poll','cell ram cache population');