Oracle 视图 V$SESSION_WAIT_HISTORY 官方解释，作用，如何使用详细说明
本站中文解释
Oracle 视图—V$SESSION_WAIT_HISTORY 记录了每个会话里等待时间最长的当前等待事件以及上一个事件的数据。V$SESSION_WAIT_HISTORY 应用于收集和诊断Oracle数据库在执行活动时出现的等待情况和执行响应时间。
使用 V$SESSION_WAIT_HISTORY:
1.通过查询V$SESSION_WAIT_HISTORY视图，可实时监控会话参数SECONDS_IN_WAIT和EVENT；
2.具体可使用如下查询语句：SELECT * FROM V$SESSION_WAIT_HISTORY WHERE ‘SID=’会话号;
3.查询结果可从SECONDS_IN_WAIT 和 EVENT 字段中获取某会话当前等待的秒数和等待的事件，从而进行实时会话监控。
官方英文解释
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:
|
