GV$DLM_RESS definition in Oracle Database 11.2
GV$DLM_RESS

select
  inst_id,                                 -- INST_ID NUMBER
  kjirftrp,                                -- RESP RAW(8)
  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(8)
  kjbrname,                                -- RESOURCE_NAME VARCHAR2(30)
  decode(kjbrcvtq, '00', 0, 1),            -- ON_CONVERT_Q NUMBER
  decode(kjbrgrantq, '00', 0, 1),          -- ON_GRANT_Q NUMBER
  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