V$ENQUEUE_STATISTICS

7.204 V$ENQUEUE_STATISTICS

V$ENQUEUE_STATISTICS displays statistics on the number of enqueue (lock) requests for each type of lock.

V$ENQUEUE_STATISTICS encompasses V$ENQUEUE_STAT and gives more detailed information (several rows for same enqueues with different reasons).

Column	Datatype	Description
`EQ_NAME`	`VARCHAR2(64)`	Name of the enqueue request
`EQ_TYPE`	`VARCHAR2(2)`	Type of enqueue requested
`REQ_REASON`	`VARCHAR2(64)`	Reason for the enqueue request
`TOTAL_REQ#`	`NUMBER`	Total number of enqueue requests or enqueue conversions for this type of enqueue
`TOTAL_WAIT#`	`NUMBER`	Total number of times an enqueue request or conversion resulted in a wait
`SUCC_REQ#`	`NUMBER`	Number of times an enqueue request or conversion was granted
`FAILED_REQ#`	`NUMBER`	Number of times an enqueue request or conversion failed
`CUM_WAIT_TIME`	`NUMBER`	Total amount of time (in milliseconds) spent waiting for the enqueue or enqueue conversion
`REQ_DESCRIPTION`	`VARCHAR2(4000)`	Description of the enqueue request
`EVENT#`	`NUMBER`	Event number
`CON_ID`	`NUMBER`	The ID of the container to which the data pertains. Possible values include: `0`: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. `1`: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data