V$GES_ENQUEUE
describes all locks currently known to lock manager. This is an Oracle Real Application Clusters view.
See Also:
"V$GES_BLOCKING_ENQUEUE" for a description of all such locks that are currently blocking or being blocked
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 to which the lock belongs |
|
|
Upper 4 bytes of the transaction identifier to which the lock belongs |
|
|
Group identifier for the lock |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Which queue the lock is currently located. |
|
|
State of the lock as the owner sees it |
|
|
Last AST event |
|
|
Node identifier |
|
|
|
|
|
|
|
|
The ID of the container to which the data pertains. Possible values include:
|