GV$DLM_RESS

select
inst_id,                 -- INST_ID NUMBER
kjirftrp,                -- RESP RAW(4)
kjirftrn,                -- RESOURCE_NAME VARCHAR2(30)
kjirftcq,                -- ON_CONVERT_Q NUMBER
kjirftgq,                -- ON_GRANT_Q NUMBER
kjirftpr,                -- PERSISTENT_RES NUMBER
kjirftmn,                -- MASTER_NODE NUMBER
kjirftncl,               -- NEXT_CVT_LEVEL VARCHAR2(9)
kjirftvs,                -- VALUE_BLK_STATE VARCHAR2(32)
kjirftvb                 -- VALUE_BLK VARCHAR2(64)
from
x$kjirft 
union all 
select
inst_id,                 -- INST_ID NUMBER
kjbrresp,                -- RESP RAW(4)
kjbrname,                -- RESOURCE_NAME VARCHAR2(30)
decode                   -- ON_CONVERT_Q NUMBER
  (kjbrcvtq, '00', 0, 1),
decode                   -- ON_GRANT_Q NUMBER
  (kjbrgrantq, '00', 0, 1),
1,                       -- PERSISTENT_RES NUMBER
kjbrmaster,              -- MASTER_NODE NUMBER
kjbrncvl,                -- NEXT_CVT_LEVEL VARCHAR2(9)
'KJUSERVS_NOVALUE',      -- VALUE_BLK_STATE VARCHAR2(32)
'0x0'                    -- VALUE_BLK VARCHAR2(64)
from
x$kjbr
home |  up  |  mailbox