Home > Oracle > Progress of Rman jobs

Progress of Rman jobs


-- RMAN Progress
 alter session set nls_date_format='dd/mm/yy hh24:mi:ss'
 /
 select SID, START_TIME,TOTALWORK, sofar, (sofar/totalwork) * 100 done,
 sysdate + TIME_REMAINING/3600/24 end_at
 from v$session_longops
 where totalwork > sofar
 AND opname NOT LIKE '%aggregate%'
 AND opname like 'RMAN%'
 /

 -- RMAN waits
 set lines 120
 column sid format 9999
 column spid format 99999
 column client_info format a25
 column event format a30
 column secs format 9999
 SELECT SID, SPID, CLIENT_INFO, event, seconds_in_wait secs, p1, p2, p3
 FROM V$PROCESS p, V$SESSION s
 WHERE p.ADDR = s.PADDR
 and CLIENT_INFO like 'rman channel=%'

Advertisements
Categories: Oracle
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: