V$SYSTEM_EVENT

Wait events since startup of the instance.

Columns

 
   EVENT
   TOTAL_WAITS
   TOTAL_TIMEOUTS
   TIME_WAITED
   AVERAGE_WAIT
   TIME_WAITED_MICRO

total_waits = A count of all wait events since startup of the instance.

time_waited = The sum of the wait times for all events in hundreth of a second. (requires timed_statistics=true)

time_waited_micro = wait times in millionths of a second.

Related:

V$ENQUEUE_STAT 
V$GLOBAL_TRANSACTION 
V$SESSION_EVENT 
V$SHARED_POOL_RESERVED 
V$SORT_SEGMENT 
V$SORT_USAGE 
V$STATNAME 
V$SYSSTAT 
V$SYSTEM_CURSOR_CACHE 
V$TRANSACTION 


 
Copyright © SS64.com 1999-2019
Some rights reserved