select
  inst_id,                                 -- INST_ID NUMBER
  id,                                      -- ID NUMBER
  name,                                    -- NAME VARCHAR2(64)
  name_nls,                                -- NAME_NLS VARCHAR2(1024)
  clsid,                                   -- CLSID NUMBER
  decode(                                  -- CLS_NAME VARCHAR2(15)
    clsid, 1, 'GENERIC', 2, 'PERSISTENT_DATA', 3, 'ASM', 'UNKNOWN'),
  flags,                                   -- FLAGS NUMBER
  decode(                                  -- INTERNAL_CHECK VARCHAR2(1)
    bitand(flags,1), 0, 'N', 'Y'),
  decode(                                  -- OFFLINE_CAPABLE VARCHAR2(1)
    bitand(flags,2), 0, 'N', 'Y'),
  description                              -- DESCRIPTION VARCHAR2(1024)
from
  x$dbkh_check
where
  bitand(flags,64) = 0