monitoring_rman
--check rman is or not connect rman target database
set linesize 132
col client_info format a45
select sid, spid, client_info
from v$process p, v$session s
where p.addr=s.paddr and
client_info like '%rman%';
--monitoring_rman
set linesize 132
col opname format a30
SELECT SID, SERIAL#,OPNAME, CONTEXT, SOFAR, TOTALWORK,
ROUND(SOFAR/TOTALWORK*100,2) "% COMPLETE",
to_char(start_time,'yymmdd HH24:mi:ss') as startT,
ELAPSED_SECONDS ELAPSED
FROM V$SESSION_LONGOPS
WHERE OPNAME LIKE 'RMAN%'
AND OPNAME NOT LIKE '%aggregate%'
AND TOTALWORK != 0
AND SOFAR <> TOTALWORK;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/807718/viewspace-269298/ ，如需转载，请注明出处，否则将追究法律责任。
