GV$RMAN_STATUS_CURRENT

select
userenv ('Instance'),    -- INST_ID NUMBER
SID_KRBMRST,             -- SID NUMBER
ID_KRBMRST,              -- RECID NUMBER
STAMP_KRBMRST,           -- STAMP NUMBER
decode                   -- PARENT_RECID NUMBER
  (LEVEL_KRBMRST, 0, to_number (NULL), PID_KRBMRST),
decode                   -- PARENT_STAMP NUMBER
  (LEVEL_KRBMRST, 0, to_number (NULL), PTS_KRBMRST),
L0ID_KRBMRST,            -- SESSION_RECID NUMBER
L0TS_KRBMRST,            -- SESSION_STAMP NUMBER
LEVEL_KRBMRST,           -- ROW_LEVEL NUMBER
decode                   -- ROW_TYPE VARCHAR2(19)
  (LEVEL_KRBMRST, 0, 'SESSION', 1, 'COMMAND', 'RECURSIVE OPERATION'),
CMDID_KRBMRST,           -- COMMAND_ID VARCHAR2(33)
UPPER (OPER_KRBMRST),    -- OPERATION VARCHAR2(33)
decode                   -- STATUS VARCHAR2(23)
  (STATUS_KRBMRST, 1, 'RUNNING', 1+8, 'RUNNING WITH WARNINGS', 1+16, 'RUNNING WITH ERRORS', 1+8+16, 'RUNNING WITH ERRORS', 2, 'COMPLETED', 2+8, 'COMPLETED WITH WARNINGS', 2+16, 'COMPLETED WITH ERRORS', 2+8+16, 'COMPLETED WITH ERRORS', 'FAILED'),
0,                       -- MBYTES_PROCESSED NUMBER
to_date                  -- START_TIME DATE
  (START_KRBMRST, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
to_date                  -- END_TIME DATE
  (END_KRBMRST, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian') 
from
x$krbmrst
home |  up  |  mailbox