Přikládám jen pár dotazů, pokud máte puštěnou obnovu nebo zálohu a nevíte, jak dlouho to asi poběží.
Hodí se to, když děláte večerní obnovu a rádi byste si aspoň na hodinku lehli, tak uvidíte, jestli úloha doběhne nebo to bude trvat déle.
SQL> SELECT sid, serial#, context, sofar, totalwork, round(sofar/totalwork*100,2) "% Complete" FROM v$session_longops WHERE opname LIKE 'RMAN%' AND opname NOT LIKE '%aggregate%' AND totalwork != 0 AND sofar <> totalwork; SID SERIAL# CONTEXT SOFAR TOTALWORK % Complete ---------- ---------- ---------- ---------- ---------- ---------- 4 49 1 2451170 6122880 40.03 SQL> COLUMN CLIENT_INFO FORMAT a30 COLUMN SID FORMAT 999 COLUMN SPID FORMAT 9999 SELECT s.SID, p.SPID, s.CLIENT_INFO FROM V$PROCESS p, V$SESSION s WHERE p.ADDR = s.PADDR AND CLIENT_INFO LIKE 'rman%'; SID SPID CLIENT_INFO ---- ------------------------ ------------------------------ 4 12817 rman channel=ORA_DISK_1 SQL> col OPNAME for a30 select OPNAME,SOFAR/TOTALWORK*100 PCT, trunc(TIME_REMAINING/60) MIN_RESTANTES, trunc(ELAPSED_SECONDS/60) MIN_ATEAGORA from v$session_longops where TOTALWORK>0 and OPNAME like '%RMAN%'; OPNAME PCT MIN_RESTANTES MIN_ATEAGORA ------------------------------ ---------- ------------- ------------ RMAN: archived log backup 100 0 0 RMAN: archived log backup 100 0 0 RMAN: archived log backup 100 0 0 RMAN: archived log backup 100 0 0 RMAN: archived log backup 100 0 0 RMAN: archived log backup 100 0 0 RMAN: full datafile restore 94.8507728 8 158 RMAN: aggregate input 100 0 0 RMAN: aggregate output 100 0 0 RMAN: aggregate output 100 0 0 RMAN: aggregate output 100 0 0 OPNAME PCT MIN_RESTANTES MIN_ATEAGORA ------------------------------ ---------- ------------- ------------ RMAN: aggregate input 100 0 0