select
  inst_id,                                 -- INST_ID NUMBER
  id,                                      -- RUN_ID NUMBER
  name,                                    -- NAME VARCHAR2(32)
  cname,                                   -- CHECK_NAME VARCHAR2(32)
  decode(                                  -- RUN_MODE VARCHAR2(8)
    runmode, 0, 'MANUAL', 1, 'AUTO', 2, 'REACTIVE', 'UNKNOWN'),
  timeout,                                 -- TIMEOUT NUMBER
  cast(stime as timestamp),                -- START_TIME TIMESTAMP(6)
  cast(rtime as timestamp),                -- LAST_RESUME_TIME TIMESTAMP(6)
  cast(etime as timestamp),                -- END_TIME TIMESTAMP(6)
  cast(mtime as timestamp),                -- MODIFIED_TIME TIMESTAMP(6)
  decode(                                  -- STATUS VARCHAR2(11)
    status, 0, 'INITITAL', 1, 'EXECUTING', 2, 'INTERRUPTED', 3, 'TIMEDOUT', 4, 'CANCELLED', 5, 'COMPLETED', 6, 'ERROR', 'UNKNOWN'),
  incident,                                -- SRC_INCIDENT NUMBER
  num_incidents,                           -- NUM_INCIDENT NUMBER
  error_number,                            -- ERROR_NUMBER NUMBER
  problem_id                               -- PROBLEM_ID NUMBER
from
  x$dbkrun