7.252 V$GLOBAL_BLOCKED_LOCKS
V$GLOBAL_BLOCKED_LOCKS
displays global blocked locks.
Column | Datatype | Description |
---|---|---|
|
|
Address of lock state object |
|
|
Address of lock |
|
|
Identifier of session holding the lock (number) |
|
|
Resource type (char) |
|
|
Resource identifier #1 (number) |
|
|
Resource identifier #2 (number) |
|
|
Lock mode held (number) |
|
|
Lock mode requested (number) |
|
|
Time since current mode was granted |
|
|
The ID of the container to which the data pertains. Possible values include:
|