9.25 V$SESSION_WAIT
V$SESSION_WAIT
displays the current or last wait for each session.
Column | Datatype | Description |
---|---|---|
|
|
Session identifier; maps to |
|
|
A number that uniquely identifies the current or last wait (incremented for each wait) |
|
|
If the session is currently waiting, then the resource or event for which the session is waiting. If the session is not in a wait, then the resource or event for which the session most recently waited. See Also: "Oracle Wait Events" |
|
|
Description of the first wait event parameter |
|
|
First wait event parameter (in decimal) |
|
|
First wait event parameter (in hexadecimal)Foot 1 |
|
|
Description of the second wait event parameter |
|
|
Second wait event parameter (in decimal) |
|
|
Second wait event parameter (in hexadecimal)Footref 1 |
|
|
Description of the third wait event parameter |
|
|
Third wait event parameter (in decimal) |
|
|
Third wait event parameter (in hexadecimal)Footref 1 |
|
|
Identifier of the class of the wait event |
|
|
Number of the class of the wait event |
|
|
Name of the class of the wait event |
|
|
If the session is currently waiting, then the value is
This column has been deprecated in favor of the columns |
|
|
If the session is currently waiting, then the value is the amount of time waited for the current wait. If the session is not in a wait, then the value is the amount of time since the start of the last wait. This column has been deprecated in favor of the columns |
|
|
Wait state:
|
|
|
Amount of time waited (in microseconds). If the session is currently waiting, then the value is the time spent in the current wait. If the session is currently not in a wait, then the value is the amount of time waited in the last wait. |
|
|
Value is interpreted as follows:
|
|
|
Time elapsed since the end of the last wait (in microseconds). If the session is currently in a wait, then the value is |
|
|
The ID of the container to which the data pertains. Possible values include:
|
Footnote 1
The P1RAW
, P2RAW
, and P3RAW
columns display the same values as the P1
, P2
, and P3
columns, except that the numbers are displayed in hexadecimal.
See Also:
"TIMED_STATISTICS" and "Oracle Wait Events"