V$GES_DEADLOCK_SESSIONS
V$GES_DEADLOCK_SESSIONS displays information about sessions waiting for global enqueue service deadlocks detected by the distributed lock manager. This is an Oracle Real Application Clusters view.
This view displays a maximum of 20 sessions per deadlock.
| Column | Datatype | Description |
|---|---|---|
DID |
VARCHAR2(30) |
Deadlock ID |
SID |
NUMBER |
Waiting session ID |
SERIAL# |
NUMBER |
Waiting session serial number |
INSTANCE |
NUMBER |
Waiting session instance |
BLOCKER_SID |
NUMBER |
Blocker session ID |
BLOCKER_SERIAL# |
NUMBER |
Blocker session serial number |
BLOCKER_INSTANCE |
NUMBER |
Blocker session instance |
OSUSER |
VARCHAR2(128) |
Waiting OS user |
APP_NAME |
VARCHAR2(64) |
Waiting application name |
BLOCKED_RES_NAME |
VARCHAR2(64) |
Resource on which the waiting session is blocked |
REQUEST_LEVEL |
VARCHAR2(16) |
Waiting session requested level |
BLOCKER_RES_NAME |
VARCHAR2(64) |
Resource on which the blocker is blocked |
GRANT_LEVEL |
VARCHAR2(16) |
Granted level of the blocker |
CON_ID |
NUMBER |
The ID of the container to which the data pertains. Possible values include:
|