GV$ROWCACHE_PARENT

select
inst_id,                 -- INST_ID NUMBER
indx,                    -- INDX NUMBER
kqrfphsh,                -- HASH NUMBER
kqrfpadd,                -- ADDRESS RAW(4)
kqrfpcid,                -- CACHE# NUMBER
kqrfpcnm,                -- CACHE_NAME VARCHAR2(64)
decode                   -- EXISTENT VARCHAR2(1)
  (bitand (kqrfpflg, 1), 0, 'Y', 'N'),
kqrfpmod,                -- LOCK_MODE NUMBER
kqrfpreq,                -- LOCK_REQUEST NUMBER
kqrfptxn,                -- TXN RAW(4)
kqrfpses,                -- SADDR RAW(4)
kqrfpirq,                -- INST_LOCK_REQUEST NUMBER
kqrfpirl,                -- INST_LOCK_RELEASE NUMBER
kqrfpity,                -- INST_LOCK_TYPE VARCHAR2(2)
kqrfpii1,                -- INST_LOCK_ID1 RAW(4)
kqrfpii2,                -- INST_LOCK_ID2 RAW(4)
kqrfpkey                 -- KEY RAW(100)
from
x$kqrfp
home |  up  |  mailbox