Release 2 (8.1.6)
Part Number A76961-01
 Library |
 Product |
 Contents |
 Index |
| Oracle8i Reference Release 2 (8.1.6) Part Number A76961-01 |
|
Dynamic Performance (V$) Views, 142 of 179
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.
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 non-zero 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-2000, Oracle Corporation. All Rights Reserved. |
|