[Home] [Help] [Dependency Information]
Object Name: | GV_$SESSION_WAIT_HISTORY |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INST_ID | NUMBER | |||
SID | NUMBER | |||
SEQ# | NUMBER | |||
EVENT# | NUMBER | |||
EVENT | VARCHAR2 | (64) | ||
P1TEXT | VARCHAR2 | (64) | ||
P1 | NUMBER | |||
P2TEXT | VARCHAR2 | (64) | ||
P2 | NUMBER | |||
P3TEXT | VARCHAR2 | (64) | ||
P3 | NUMBER | |||
WAIT_TIME | NUMBER | |||
WAIT_TIME_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#
, EVENT
, P1TEXT
, P1
, P2TEXT
, P2
, P3TEXT
, P3
, WAIT_TIME
, WAIT_TIME_MICRO
, TIME_SINCE_LAST_WAIT_MICRO
, CON_ID
FROM SYS.GV_$SESSION_WAIT_HISTORY;
|
|
|