RMAN -1

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

-- Run in root container

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

COL in_sec FORMAT a10

COL out_sec FORMAT a10

COL TIME_TAKEN_DISPLAY FORMAT a10

SELECT SESSION_KEY, 

       OPTIMIZED, 

       COMPRESSION_RATIO, 

       INPUT_BYTES_PER_SEC_DISPLAY in_sec,

       OUTPUT_BYTES_PER_SEC_DISPLAY out_sec, 

       TIME_TAKEN_DISPLAY

FROM   V$RMAN_BACKUP_JOB_DETAILS

ORDER BY SESSION_KEY;

select s.inst_id, o.sid, CLIENT_INFO ch, context, sofar, totalwork,

                    round(sofar/totalwork*100,2) "% Complete"

     FROM gv$session_longops o, gv$session s

     WHERE opname LIKE 'RMAN%'

     AND opname NOT LIKE '%aggregate%'

     AND o.sid=s.sid

     AND totalwork != 0

     AND sofar <> totalwork;

select SID, START_TIME,TOTALWORK, sofar, round((sofar/totalwork) * 100)  done,

to_char(sysdate + TIME_REMAINING/3600/24,'dd-MON-yy hh:mi AM') end_at

from gv$session_longops

where totalwork > sofar

AND opname NOT LIKE '%aggregate%'

AND opname like 'RMAN%'

/

SELECT SID, SPID, CLIENT_INFO, event, seconds_in_wait secs, p1, p2, p3

  FROM gV$PROCESS p, gV$SESSION s

  WHERE p.ADDR = s.PADDR

  and  p.inst_id = s.inst_id

  and CLIENT_INFO   like '%rman%'

/

SELECT sid, serial#, sofar, totalwork, opname,

round(sofar/totalwork*100,2) AS pct_complete

FROM gv$session_longops

WHERE opname LIKE 'RMAN%'

AND opname NOT LIKE '%aggregate%'

AND totalwork != 0

AND sofar <> totalwork;