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

Object Details

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

[View Source]

Columns

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

Query Text

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


SELECT 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.V_$SESSION_WAIT;

Dependencies

[top of page]

SYS.V_$SESSION_WAIT references the following:

SYS.V_$SESSION_WAIT is referenced by following:

PUBLIC: V$SESSION_WAIT