../E40402-16.epub /> ../E40402-16.mobi />

V$GES_BLOCKING_ENQUEUE

V$GES_BLOCKING_ENQUEUE 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. This is a Real Application Clusters view.

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