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_BLOCKING_ENQUEUE

This Real Application Clusters view describes all locks currently known to lock manager that are being blocked or blocking others. The output of this view is a subset of the output from V$GES_ENQUEUE.


See Also:

"V$GES_ENQUEUE" for a description of all locks known to the lock manager

Column Datatype Description
HANDLE RAW(4 | 8) Lock pointer
GRANT_LEVEL VARCHAR2(9) Granted level of the lock
REQUEST_LEVEL VARCHAR2(9) Requested level of the lock
RESOURCE_NAME1 VARCHAR2(30) Resource name for the lock
RESOURCE_NAME2 VARCHAR2(30) Resource name for the lock
PID NUMBER Process identifier which holds the lock
TRANSACTION_ID0 NUMBER Lower 4 bytes of the transaction identifier where the lock belongs to
TRANSACTION_ID1 NUMBER Upper 4 bytes of the transaction identifier where the lock belongs to
GROUP_ID NUMBER Group identifier for the lock
OPEN_OPT_DEADLOCK NUMBER 1 if DEADLOCK open option is set, otherwise 0
OPEN_OPT_PERSISTENT NUMBER 1 if PERSISTENT open option is set, otherwise 0
OPEN_OPT_PROCESS_OWNED NUMBER 1 if PROCESS_OWNED open option is set, otherwise 0
OPEN_OPT_NO_XID NUMBER 1 if NO_XID open option is set, otherwise 0
CONVERT_OPT_GETVALUE NUMBER 1 if GETVALUE convert option is set, otherwise 0
CONVERT_OPT_PUTVALUE NUMBER 1 if PUTVALUE convert option is set, otherwise 0
CONVERT_OPT_NOVALUE NUMBER 1 if NOVALUE convert option is set, otherwise 0
CONVERT_OPT_DUBVALUE NUMBER 1 if DUBVALUE convert option is set, otherwise 0
CONVERT_OPT_NOQUEUE NUMBER 1 if NOQUEUE convert option is set, otherwise 0
CONVERT_OPT_EXPRESS NUMBER 1 if EXPRESS convert option is set, otherwise 0
CONVERT_OPT_NODEADLOCKWAIT NUMBER 1 if NODEADLOCKWAIT convert option is set, otherwise 0
CONVERT_OPT_NODEADLOCKBLOCK NUMBER 1 if NODEADLOCKBLOCK convert option is set, otherwise 0
WHICH_QUEUE NUMBER Which queue the lock is currently located. 0 for NULL queue; 1 for GRANTED queue; 2 for CONVERT queue.
STATE VARCHAR2(64) State of lock as owner sees it
AST_EVENT0 NUMBER Last AST event
OWNER_NODE NUMBER Node identifier
BLOCKED NUMBER 1 if this lock request is blocked by others, otherwise 0
BLOCKER NUMBER 1 if this lock is blocking others, otherwise 0