Tuesday, January 29, 2013
Track RMAN Job Process via gv$session_longops
Nice way to track RMAN Channel worker progress
Also useful: watch -n 10 sqlplus -s usr/pwd [this script].sql
set linesize 120
column pct_done format '999.99'
column opname format a35
column time_left format a15
column started format a15
select
sid,
opname,
to_char(start_time,'DD-MON HH24:MI') started,
round(totalwork-sofar) blocks_left,
(sofar/totalwork) * 100 pct_done,
to_char(to_date(time_remaining,'sssss'),'hh24:mi:ss') time_left
from
gv$session_longops
where
totalwork > sofar
AND
opname NOT LIKE '%aggregate%'
AND
opname like 'RMAN%'
order by 2;
exit;
Labels:
Backup,
Monitoring,
Oracle,
RMAN
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment