select
  inst_id,                                 -- INST_ID NUMBER
  incident_id,                             -- INCIDENT_ID NUMBER
  ctime,                                   -- CREATE_TIME TIMESTAMP(13) WITH TIME ZONE
  decode(                                  -- IS_DISABLED VARCHAR2(1)
    is_disabled, 0, 'N', 1, 'Y'),
  decode(                                  -- IS_ACTIVE VARCHAR2(1)
    is_active, 0, 'N', 1, 'Y'),
  decode(                                  -- IMPT_NATURE VARCHAR2(14)
    is_pers_impt, 0, 'TRANSIENT', 1, 'PERSISTENT', 'UNKNOWN       '),
  impact1,                                 -- IMPACT1 VARCHAR2(128)
  impact2,                                 -- IMPACT2 VARCHAR2(128)
  impact3,                                 -- IMPACT3 VARCHAR2(128)
  impact4                                  -- IMPACT4 VARCHAR2(128)
from
  x$dbkincmetinfo