[Home] [Help] [Dependency Information]
Object Name: | GV_$GES_DEADLOCK_SESSIONS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INST_ID | NUMBER | |||
DID | VARCHAR2 | (30) | ||
SID | NUMBER | |||
SERIAL# | NUMBER | |||
INSTANCE | NUMBER | |||
BLOCKER_SID | NUMBER | |||
BLOCKER_SERIAL# | NUMBER | |||
BLOCKER_INSTANCE | NUMBER | |||
OSUSER | VARCHAR2 | (30) | ||
APP_NAME | VARCHAR2 | (64) | ||
BLOCKED_RES_NAME | VARCHAR2 | (64) | ||
REQUEST_LEVEL | VARCHAR2 | (16) | ||
BLOCKER_RES_NAME | VARCHAR2 | (64) | ||
GRANT_LEVEL | VARCHAR2 | (16) | ||
CON_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT INST_ID
, DID
, SID
, SERIAL#
, INSTANCE
, BLOCKER_SID
, BLOCKER_SERIAL#
, BLOCKER_INSTANCE
, OSUSER
, APP_NAME
, BLOCKED_RES_NAME
, REQUEST_LEVEL
, BLOCKER_RES_NAME
, GRANT_LEVEL
, CON_ID
FROM SYS.GV_$GES_DEADLOCK_SESSIONS;
|
|
|