7.242 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 |
---|---|---|
|
|
Lock pointer |
|
|
Granted level of the lock |
|
|
Requested level of the lock |
|
|
Resource name for the lock |
|
|
Resource name for the lock |
|
|
Process identifier which holds the lock |
|
|
Lower 4 bytes of the transaction identifier where the lock belongs to |
|
|
Upper 4 bytes of the transaction identifier where the lock belongs to |
|
|
Group identifier for the lock |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Which queue the lock is currently located. |
|
|
State of lock as owner sees it |
|
|
Last AST event |
|
|
Node identifier |
|
|
|
|
|
|
|
|
The ID of the container to which the data pertains. Possible values include:
|