[Home] [Help] [Dependency Information]
Object Name: | GV_$SESSION_WAIT |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INST_ID | NUMBER | |||
SID | NUMBER | |||
SEQ# | NUMBER | |||
EVENT | VARCHAR2 | (64) | ||
P1TEXT | VARCHAR2 | (64) | ||
P1 | NUMBER | |||
P1RAW | RAW | (8) | ||
P2TEXT | VARCHAR2 | (64) | ||
P2 | NUMBER | |||
P2RAW | RAW | (8) | ||
P3TEXT | VARCHAR2 | (64) | ||
P3 | NUMBER | |||
P3RAW | RAW | (8) | ||
WAIT_CLASS_ID | NUMBER | |||
WAIT_CLASS# | NUMBER | |||
WAIT_CLASS | VARCHAR2 | (64) | ||
WAIT_TIME | NUMBER | |||
SECONDS_IN_WAIT | NUMBER | |||
STATE | VARCHAR2 | (19) | ||
WAIT_TIME_MICRO | NUMBER | |||
TIME_REMAINING_MICRO | NUMBER | |||
TIME_SINCE_LAST_WAIT_MICRO | NUMBER | |||
CON_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT INST_ID
, SID
, SEQ#
, EVENT
, P1TEXT
, P1
, P1RAW
, P2TEXT
, P2
, P2RAW
, P3TEXT
, P3
, P3RAW
, WAIT_CLASS_ID
, WAIT_CLASS#
, WAIT_CLASS
, WAIT_TIME
, SECONDS_IN_WAIT
, STATE
, WAIT_TIME_MICRO
, TIME_REMAINING_MICRO
, TIME_SINCE_LAST_WAIT_MICRO
, CON_ID
FROM SYS.GV_$SESSION_WAIT;
|
|
|