select
  inst_id,                                 -- INST_ID NUMBER
  gn_kfncl,                                -- GROUP_NUMBER NUMBER
  instname_kfncl,                          -- INSTANCE_NAME VARCHAR2(64)
  dbname_kfncl,                            -- DB_NAME VARCHAR2(8)
  decode(                                  -- STATUS VARCHAR2(12)
    status_kfncl, 1, 'CONNECTED', 2, 'DISCONNECTED', 3, 'BROKEN'),
  softver_kfncl,                           -- SOFTWARE_VERSION VARCHAR2(60)
  compver_kfncl                            -- COMPATIBLE_VERSION VARCHAR2(60)
from
  x$kfncl