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 an Oracle 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, otherwise0 |
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 |
CON_ID |
NUMBER |
The ID of the container to which the data pertains. Possible values include:
|