Oracle9i Database Reference Release 2 (9.2) Part Number A96536-01 |
|
Dynamic Performance (V$) Views, 173 of 237
This view lists information on waits for an event by a session. 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. Please remember that doing this will have a small negative effect on system performance.
Column | Datatype | Description |
---|---|---|
|
|
The ID of the session |
|
|
See Also: Appendix A, "Oracle Wait Events" |
|
|
The total number of waits for this event by this session |
|
|
The total number of timeouts for this event by this session |
|
|
The total amount of time waited for this event by this session, in hundredths of a second |
|
|
The average amount of time waited for this event by this session, in hundredths of a second |
|
|
The maximum time (in hundredths of a second) waited for this event by this session |
|
Copyright © 1996, 2002 Oracle Corporation. All Rights Reserved. |
|