eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: SYS.V_$SESSION_WAIT_HISTORY

Object Details

Object Name:	V_$SESSION_WAIT_HISTORY
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
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

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SID
,      SEQ#
,      EVENT#
,      EVENT
,      P1TEXT
,      P1
,      P2TEXT
,      P2
,      P3TEXT
,      P3
,      WAIT_TIME
,      WAIT_TIME_MICRO
,      TIME_SINCE_LAST_WAIT_MICRO
,      CON_ID
FROM SYS.V_$SESSION_WAIT_HISTORY;

Dependencies

[top of page]

SYS.V_$SESSION_WAIT_HISTORY references the following:

SYS.V_$SESSION_WAIT_HISTORY is referenced by following:

PUBLIC: V$SESSION_WAIT_HISTORY