Dynamic Performance (V$) Views, 50 of 179

V$DLM_RESS

V$DLM_RESS is an Oracle Parallel Server view. It displays information of all resources currently known to the lock manager.

Column	Datatype	Description
`RESP`	`RAW(4)`	Resource pointer
`RESOURCE_NAME`	`VARCHAR2(30)`	Resource name in hexadecimal for the lock
`ON_CONVERT_Q`	`NUMBER`	1 if on convert queue, 0 otherwise
`ON_GRANT_Q`	`NUMBER`	1 if on granted queue, 0 otherwise
`PERSISTENT_RES`	`NUMBER`	1 if it is a persistent resource, 0 otherwise
`RDOMAIN_NAME`	`VARCHAR2(25)`	Recovery domain name
`RDOMAINP`	`RAW(4)`	Recovery domain pointer
`MASTER_NODE`	`NUMBER`	Master node ID
`NEXT_CVT_LEVEL`	`VARCHAR2(9)`	Next lock level to convert on global convert queue
`VALUE_BLK_STATE`	`VARCHAR2(32)`	State of the value block
`VALUE_BLK`	`VARCHAR2(64)`	First 64 bytes of the value block