[Home] [Help] [Dependency Information]
Object Name: | GV_$SESSION_BLOCKERS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INST_ID | NUMBER | |||
SID | NUMBER | |||
SESS_SERIAL# | NUMBER | |||
WAIT_ID | NUMBER | |||
WAIT_EVENT | NUMBER | |||
WAIT_EVENT_TEXT | VARCHAR2 | (64) | ||
BLOCKER_INSTANCE_ID | NUMBER | |||
BLOCKER_SID | NUMBER | |||
BLOCKER_SESS_SERIAL# | NUMBER | |||
CON_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT INST_ID
, SID
, SESS_SERIAL#
, WAIT_ID
, WAIT_EVENT
, WAIT_EVENT_TEXT
, BLOCKER_INSTANCE_ID
, BLOCKER_SID
, BLOCKER_SESS_SERIAL#
, CON_ID
FROM SYS.GV_$SESSION_BLOCKERS;
|
|
|