Query:
=====
col TARGET for a25
set lines 300
col OPNAME for a50
SELECT target,OPNAME,sum(sofar), sum(totalwork),sum(sofar)*100/sum(totalwork) Percntg,sum(ELAPSED_SECONDS/60) ETIME,max(time_remaining/60) RTIME
FROM v$session_longops WHERE time_remaining > 0 and sofar!=totalwork and OPNAME like '%RMAN%' group by target,OPNAME;
=====
col TARGET for a25
set lines 300
col OPNAME for a50
SELECT target,OPNAME,sum(sofar), sum(totalwork),sum(sofar)*100/sum(totalwork) Percntg,sum(ELAPSED_SECONDS/60) ETIME,max(time_remaining/60) RTIME
FROM v$session_longops WHERE time_remaining > 0 and sofar!=totalwork and OPNAME like '%RMAN%' group by target,OPNAME;

No comments:
Post a Comment