Script to monitor RMAN progress

Hello friends,

Today, came up with a restore task, just thought of sharing the script which I used to monitor RMAN restore progress.

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;

select sid, start_time, totalwork sofar, (sofar/totalwork) * 100 pct_done from
v$session_longops where totalwork > sofar AND opname NOT LIKE '%aggregate%' AND
opname like 'RMAN%';

select sid, spid, client_info, event, p1, p2, p3 from v$process p, v$session s
where p.addr = s.paddr and client_info like 'rman channel=%';