|
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
. |
|
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。
|
WAIT_TIME |
NUMBER |
|
Total wait time (in microseconds) for the event for which the session last waited (
0
if currently waiting) |
免责声明：本站发布的内容（图片、视频和文字）以原创、转载和分享为主，文章观点不代表本网站立场，如果涉及侵权请联系站长邮箱：is@yisu.com进行举报，并提供相关证据，一经查实，将立刻删除涉嫌侵权内容。
