select
  inst_id,                                 -- INST_ID NUMBER
  id,                                      -- FAILURE_ID NUMBER
  pid,                                     -- PARENT_ID NUMBER
  cid_count,                               -- CHILD_COUNT NUMBER
  clsname,                                 -- CLASS_NAME VARCHAR2(32)
  cast(ctime as date),                     -- TIME_DETECTED DATE
  cast(mtime as date),                     -- MODIFIED DATE
  fdg_msg,                                 -- DESCRIPTION VARCHAR2(1024)
  damage_msg,                              -- IMPACTS VARCHAR2(1024)
  decode(                                  -- PRIORITY VARCHAR2(8)
    priority, 0, 'CRITICAL', 1, 'HIGH', 2, 'LOW', 'UNKNOWN'),
  decode(                                  -- STATUS VARCHAR2(12)
    status, 0, 'OPEN', 1, 'CLOSED', 2, 'UNDER-REPAIR', 'UNKNOWN') 
from
  x$dbkfdg
where
  type = 1 and clsnameid = 2 and bitand(FLAGS,3) = 0