溫馨提示×

溫馨提示×

您好，登錄后才能下訂單哦！

密碼登錄×
登錄注冊×
其他方式登錄
點擊 登錄注冊 即表示同意《億速云用戶服務條款》

session視圖中wait_time

發(fā)布時間：2020-08-14 13:47:11 來源：ITPUB博客 閱讀：160 作者：darren__chan 欄目：關系型數(shù)據(jù)庫
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狀態(tài)的間隔時間，單位為1/100秒。
3.wait_time為-1時，指的是從上一次waiting到當前非waiting狀態(tài)的間隔時間小于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 ，當在采樣時，會話狀態(tài)是waiting。

2.wait_time大于0,當在采樣時，會話狀態(tài)是on cpu，這個值便是從往上最后一次狀態(tài)為waitting到當前的時間區(qū)間。
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 ，當在采樣時，會話狀態(tài)是waiting。
2.wait_time大于0,當在采樣時，會話狀態(tài)是on cpu，這個值便是從往上最后一次狀態(tài)為waitting到當前的時間區(qū)間。
3.這里的采樣頻率是10s.
向AI問一下細節(jié)

免責聲明：本站發(fā)布的內(nèi)容（圖片、視頻和文字）以原創(chuàng)、轉(zhuǎn)載和分享為主，文章觀點不代表本網(wǎng)站立場，如果涉及侵權請聯(lián)系站長郵箱：is@yisu.com進行舉報，并提供相關證據(jù)，一經(jīng)查實，將立刻刪除涉嫌侵權內(nèi)容。

AI
助
手