V$DLM_RESS definition in Oracle Database 11.2
V$DLM_RESS

select
  RESP,                                    -- RESP RAW(8)
  RESOURCE_NAME,                           -- RESOURCE_NAME VARCHAR2(30)
  ON_CONVERT_Q,                            -- ON_CONVERT_Q NUMBER
  ON_GRANT_Q,                              -- ON_GRANT_Q NUMBER
  PERSISTENT_RES,                          -- PERSISTENT_RES NUMBER
  MASTER_NODE,                             -- MASTER_NODE NUMBER
  NEXT_CVT_LEVEL,                          -- NEXT_CVT_LEVEL VARCHAR2(9)
  VALUE_BLK_STATE,                         -- VALUE_BLK_STATE VARCHAR2(32)
  VALUE_BLK                                -- VALUE_BLK VARCHAR2(64)
from
  GV$DLM_RESS
where
  INST_ID = USERENV('Instance')

home |  up