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