select
  inst_id,                                 -- INST_ID NUMBER
  indx,                                    -- INDX NUMBER
  kqrfphsh,                                -- HASH NUMBER
  kqrfpadd,                                -- ADDRESS RAW(8)
  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(8)
  kqrfpses,                                -- SADDR RAW(8)
  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