rman monitor

RMAN-08512: waiting for snapshot controlfile enqueue ERROR

================================================

SELECT s.sid, username AS "User", program, module, action, logon_time

"Logon", L.*

FROM v$session s, v$enqueue_lock L

WHERE L.sid = s.sid and L.type = 'CF' AND L.id1 = 0 and l.id2 = 2;

RMAN second server process polling in V$SESSION_LONGOPS

=============================================

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

query to monitor the size of buffers on a per-file basis while the backup is running

==============================================================

SELECT set_count, device_type, type, filename,

buffer_size, buffer_count, open_time, close_time

FROM v$backup_async_io

ORDER BY set_count,type, open_time, close_time;

estimated completion percentage for each channel process.

============================================