select
  SID,                                     -- SID NUMBER
  RECID,                                   -- RECID NUMBER
  STAMP,                                   -- STAMP NUMBER
  SESSION_RECID,                           -- SESSION_RECID NUMBER
  SESSION_STAMP,                           -- SESSION_STAMP NUMBER
  OUTPUT,                                  -- OUTPUT VARCHAR2(130)
  RMAN_STATUS_RECID,                       -- RMAN_STATUS_RECID NUMBER
  RMAN_STATUS_STAMP,                       -- RMAN_STATUS_STAMP NUMBER
  SESSION_RECID                            -- SESSION_KEY NUMBER
from
  GV$RMAN_OUTPUT
where
  inst_id = USERENV('Instance')