rman session progress commands

[Srikrishna Murthy Annam]

If you running any rman command and would like to know the progress of the rman sessions in the database. please use the following commands.

COLUMN CLIENT_INFO FORMAT a30

COLUMN SID FORMAT 99999

COLUMN SPID FORMAT 999999

SELECT s.SID, p.SPID, s.CLIENT_INFO FROM V$PROCESS p, V$SESSION s WHERE p.ADDR = s.PADDR AND CLIENT_INFO LIKE 'rman%';

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;