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) |