Search notes:
Oracle: V$ENQUEUE_STAT
If there are a lot of enqueue waits in
v$system_event or
v$session_event,
v$enqueue_stat
allows to break down those enqueues into enqueue classes.
For each such class, the gets, waits, failures and the cumulative sum of waited time can be found.
For a list of enqueue types, refer to enqueue types in
x$ksqst
.
The value of
cum_wait_time
originates from
x$ksqst.ksqstwtim
.