select
  inst_id,                                 -- INST_ID NUMBER
  indx,                                    -- INDX NUMBER
  kqrfshsh,                                -- HASH NUMBER
  kqrfsadd,                                -- ADDRESS RAW(8)
  kqrfscid,                                -- CACHE# NUMBER
  kqrfssid,                                -- SUBCACHE# NUMBER
  kqrfssnm,                                -- SUBCACHE_NAME VARCHAR2(64)
  decode(                                  -- EXISTENT VARCHAR2(1)
    bitand(kqrfsflg, 1), 0, 'Y', 'N'),
  kqrfspar,                                -- PARENT RAW(8)
  kqrfskey                                 -- KEY RAW(100)
from
  x$kqrfs