9.27 V$SESSION_WAIT_HISTORY
V$SESSION_WAIT_HISTORY
displays the last 10 wait events for each active session.
Column | Datatype | Description |
---|---|---|
|
|
Session identifier |
|
|
Sequence of wait events; |
|
|
Event number |
|
|
Resource or event for which the session is waiting |
|
|
Description of the first wait event parameter |
|
|
First wait event parameter (in decimal) |
|
|
Description of the second wait event parameter |
|
|
Second wait event parameter (in decimal) |
|
|
Description of the third wait event parameter |
|
|
Third wait event parameter (in decimal) |
|
|
Amount of time waited (in hundredths of a second) |
|
|
Amount of time waited (in microseconds) |
|
|
Time elapsed (in microseconds) since the end of the previous wait in the wait history |
|
|
The ID of the container to which the data pertains. Possible values include:
|