Oracle9i Database Reference Release 1 (9.0.1) Part Number A90190-02 |
|
Dynamic Performance (V$) Views, 163 of 211
This view lists the resources or events for which active sessions are waiting.
The following are tuning considerations:
P1RAW
, P2RAW
, and P3RAW
display the same values as the P1
, P2
, and P3
columns, except that the numbers are displayed in hexadecimal.
WAIT_TIME
column contains a value of -2 on 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 the TIMED_STATISTICS
parameter to TRUE
. Remember that doing this has a small negative effect on system performance.
In previous releases the WAIT_TIME
column contained an arbitrarily large value instead of a negative value to indicate the platform did not have a fast timing mechanism.
STATE
column interprets the value of WAIT_TIME
and describes the state of the current or most recent wait.
Column | Datatype | Description |
---|---|---|
|
|
Session identifier |
|
|
Sequence number that uniquely identifies this wait. Incremented for each wait. |
|
|
Resource or event for which the session is waiting See Also: Appendix A, "Oracle Wait Events" |
|
|
Description of first additional parameter |
|
|
First additional parameter |
|
|
First additional parameter |
|
|
Description of second parameter |
|
|
Second additional parameter |
|
|
Second additional parameter |
|
|
Description of third parameter |
|
|
Third additional parameter |
|
|
Third additional parameter |
|
|
A nonzero value is the session's last wait time. A zero value means the session is currently waiting. |
|
|
The seconds in wait |
|
|
Wait state: |
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|