GV$ROWCACHE_SUBORDINATE

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