Skip Headers

Oracle9i Database Reference
Release 2 (9.2)

Part Number A96536-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page Go to next page
View PDF

V$SYSTEM_EVENT

This view contains information on total waits for an event. Note that the TIME_WAITED and AVERAGE_WAIT columns will contain a value of zero on those platforms that do not support a fast timing mechanism. If you are running on one of these platforms and you want this column to reflect true wait times, you must set TIMED_STATISTICS to TRUE in the parameter file; doing this will have a small negative effect on system performance.

See Also:

"TIMED_STATISTICS"

Column Datatype Description

EVENT

VARCHAR2(64)

The name of the wait event

TOTAL_WAITS

NUMBER

The total number of waits for this event

TOTAL_TIMEOUTS

NUMBER

The total number of timeouts for this event

TIME_WAITED

NUMBER

The total amount of time waited for this event, in hundredths of a second

AVERAGE_WAIT

NUMBER

The average amount of time waited for this event, in hundredths of a second