Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

V$GES_RESOURCE

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 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 | 8) 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