select
  ID,                                      -- ID NUMBER
  NAME,                                    -- NAME VARCHAR2(64)
  NAME_NLS,                                -- NAME_NLS VARCHAR2(1024)
  CLSID,                                   -- CLSID NUMBER
  CLS_NAME,                                -- CLS_NAME VARCHAR2(15)
  FLAGS,                                   -- FLAGS NUMBER
  INTERNAL_CHECK,                          -- INTERNAL_CHECK VARCHAR2(1)
  OFFLINE_CAPABLE,                         -- OFFLINE_CAPABLE VARCHAR2(1)
  DESCRIPTION                              -- DESCRIPTION VARCHAR2(1024)
from
  GV$HM_CHECK
where
  inst_id=USERENV('Instance')