Databases Reference
In-Depth Information
F
EVENT
: The resource or event for which the session is waiting
F
P1
,
P2
,
P3
: Wait event parameters
F
WAIT_TIME
: This is set to:
-2
if
TIMED_STATISTICS
is set to false
-1
if the last wait duration was less than a hundredth of a second
0
if the session is currently waiting
A value greater than zero, which is the duration of the last wait in
hundredths of a second
F
LAST_CALL_ET
: The elapsed time in seconds since the session has become
active/inactive
F
SQL_ID
: The identifier of the currently executed SQL statement
F
PREV_SQL_ID
: The identifier of the last SQL statement executed
F
ROW_WAIT_BLOCK#
: The identifier for the block containing the row specified in
ROW_WAIT_ROW#
F
ROW_WAIT_ROW#
: The current row being locked
F
ROW_WAIT_FILE#
: The file identifier for the datafile containing the row specified
in
ROW_WAIT_ROW#
F
ROW_WAIT_OBJ#
: The object ID for the table containing the row specified in
ROW_WAIT_ROW#
See also
F
The
V$SESSION_EVENT
and
V$SESSTAT
sections in this appendix
V$SESSION_EVENT
This view displays information on waits for an event by a session.
Fields
The most relevant view fields are as follows:
F
SID
: The session identifier
F
EVENT
: The name of the wait event
F
TOTAL_WAITS
: The total number of waits for the event in the session
F
TOTAL_TIMEOUTS
: The total number of timeouts for the event in the session