Jeden ze způsobů, jak monitorovat backup job, je s využitím tabulky v$session_longops, ve které jsou uchovány informace o dlouho trvajících ulohách.

RMAN> backup device type sbt database;

Starting backup at 2010-06-23:14:51:30
released channel: ORA_DISK_1
allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: SID=52 device type=SBT_TAPE
channel ORA_SBT_TAPE_1: WARNING: Oracle Test Disk API
channel ORA_SBT_TAPE_1: starting full datafile backup set
channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATA/orcl/system01.dbf
channel ORA_SBT_TAPE_1: starting piece 1 at 2010-06-23:14:51:32
channel ORA_SBT_TAPE_1: finished piece 1 at 2010-06-23:14:52:57
piece handle=1mlgv7jj_1_1 tag=TAG20100623T145131 comment=API Version 2.0,MMS Version 8.1.3.0
channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:01:25
channel ORA_SBT_TAPE_1: starting full datafile backup set
channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
input datafile file number=00002 name=+DATA/orcl/sysaux01.dbf
channel ORA_SBT_TAPE_1: starting piece 1 at 2010-06-23:14:52:57
channel ORA_SBT_TAPE_1: finished piece 1 at 2010-06-23:14:54:12
piece handle=1nlgv7m9_1_1 tag=TAG20100623T145131 comment=API Version 2.0,MMS Version 8.1.3.0

Následující dotaz vám podá informace o běžících úlohách.

SELECT 'Detail Progress Information (per file)'"Detail Data" from dual;
SELECT SID, START_TIME, ELAPSED_SECONDS, TIME_REMAINING
FROM   V$SESSION_LONGOPS
WHERE  OPNAME LIKE 'RMAN%'
AND    OPNAME NOT LIKE '%aggregate%'
AND    TOTALWORK != 0
AND    SOFAR <> TOTALWORK;
SELECT 'Aggregate Progress Information' "Aggregate Data" from dual;
SELECT SID, SERIAL#, CONTEXT, SOFAR, TOTALWORK,
ROUND(SOFAR/TOTALWORK*100,2) "%_COMPLETE"
FROM   V$SESSION_LONGOPS
WHERE  OPNAME LIKE 'RMAN%'
AND    OPNAME LIKE '%aggregate%'
AND    TOTALWORK != 0
AND    SOFAR <> TOTALWORK;

Výstup:

Detail Data
--------------------------------------
Detail Progress Information (per file)


SID START_TIME          ELAPSED_SECONDS TIME_REMAINING
---------- ------------------- --------------- --------------
52 2010-06-23:14:52:57              23             35


Aggregate Data
------------------------------
Aggregate Progress Information


SID    SERIAL#    CONTEXT      SOFAR  TOTALWORK %_COMPLETE
---------- ---------- ---------- ---------- ---------- ----------
51         35         56      87040     186240      46.74