V$ENQUEUE_STAT

Allows breaking down enqueue waits into enqueue classes. Measure gets, waits, failures and the cumulative sum of waited time for each class.

Columns

 
   INST_ID
   EQ_TYPE
   TOTAL_REQ#
   TOTAL_WAIT#
   SUCC_REQ#
   FAILED_REQ#
   CUM_WAIT_TIME

Related:

V$SESSION_EVENT
V$SYSTEM_EVENT 


© Copyright SS64.com 1999-2014
Some rights reserved