session视图中wait_time

发布时间:2020-08-14 13:47:11 作者:darren__chan
来源:ITPUB博客 阅读:166
V$SESSION
WAIT_TIME
NUMBER
If the session is currently waiting, then the value is 0 . If the session is not in a wait, then the value is as follows:
> 0 - Value is the duration of the last wait in hundredths of a second
-1 - Duration of the last wait was less than a hundredth of a second
-2 - Parameter TIMED_STATISTICS was set to false
This column has been deprecated in favor of the columns WAIT_TIME_MICRO and STATE .
1.当会话的state为waiting时,wait_time为0.
2.wait_time 大于0时,指的是从上一次waiting到当前非waiting状态的间隔时间,单位为1/100秒。
3.wait_time为-1时,指的是从上一次waiting到当前非waiting状态的间隔时间小于1/100秒。
4.wait_time为-2时,TIMED_STATISTICS 设成了fasle。
V$ACTIVE_SESSION_HISTORY
WAIT_TIME
NUMBER
0 if the session was waiting at the time of sampling
Total wait time for the event for which the session last waited if the session was on the CPU when sampled
Whether or not WAIT_TIME = 0 is what is useful to find the SESSION_STATE at the time of sampling, rather than the actual value of WAIT_TIME itself. Maps to V$SESSION.WAIT_TIME .

1.wait_time为0 ,当在采样时,会话状态是waiting。

2.wait_time大于0,当在采样时,会话状态是on cpu,这个值便是从往上最后一次状态为waitting到当前的时间区间。
3.这里的采样频率是1s.
DBA_HIST_ACTIVE_SESS_HISTORY
WAIT_TIME
NUMBER

Total wait time (in microseconds) for the event for which the session last waited ( 0 if currently waiting)
1.wait_time为0 ,当在采样时,会话状态是waiting。
2.wait_time大于0,当在采样时,会话状态是on cpu,这个值便是从往上最后一次状态为waitting到当前的时间区间。
3.这里的采样频率是10s.
推荐阅读:
  1. The Model–View Transform(模型视口变换)
  2. 视图中如何使用rowid字段

免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。

session time wait

上一篇:Postman实现参数化的方法及原理解析

下一篇:vue把路由单独分离出来的方法

相关阅读

您好,登录后才能下订单哦!

密码登录
登录注册
其他方式登录
点击 登录注册 即表示同意《亿速云用户服务条款》