| Oracle® Database Reference 11g Release 2 (11.2) Part Number E25513-03 | 
 | 
| 
 | PDF · Mobi · ePub | 
V$GES_RESOURCE is a Real Application Clusters view. It displays information of all resources currently known to the lock manager.
| Column | Datatype | Description | 
|---|---|---|
| RESP | RAW(4 | 8) | Resource pointer | 
| RESOURCE_NAME | VARCHAR2(30) | Resource name in hexadecimal for the lock | 
| ON_CONVERT_Q | NUMBER | 1if on convert queue,0otherwise | 
| ON_GRANT_Q | NUMBER | 1if on granted queue,0otherwise | 
| PERSISTENT_RES | NUMBER | 1if it is a persistent resource,0otherwise | 
| 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 |