Wait_time in session view

V$SESSIONWAIT_TIMENUMBERIf 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. When the state of the session is waiting, the wait_time is 0. When 2.wait_time is greater than 0, it refers to the interval between the last waiting and the current non-waiting state, in units of 100 seconds. A 3.wait_time of-1 means that the interval between the last waiting and the current non-waiting state is less than 100 seconds. When 4.wait_time is-2, TIMED_STATISTICS is set to fasle. V$ACTIVE_SESSION_HISTORYWAIT_TIMENUMBER0 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 is 0, and when sampling, the session state is waiting.

When 2.wait_time is greater than 0, when sampling, the session state is on cpu, which is the time interval from the last state up to waitting to the current time. 3. The sampling frequency here is 1s. DBA_HIST_ACTIVE_SESS_HISTORYWAIT_TIMENUMBER

Total wait time (in microseconds) for the event for which the session last waited (0 if currently waiting) 1.wait_time is 0, and when sampling, the session state is waiting. When 2.wait_time is greater than 0, when sampling, the session state is on cpu, which is the time interval from the last state up to waitting to the current time. 3. The sampling frequency here is 10s.