Oracle enqueue conversions

Oracle Consulting Tips by Burleson

The enqueue conversions Oracle metric is the total number of enqueue converts. For a complete description of the v$ views, get the "free 11g poster" sponsored by Quest Software.

The v$enqueue_stat view shows enqueue conversions, and also see:

Oracle stats$enqueuestat

Oracle dba_hist_enqueue_stat

This view displays statistics on the number of enqueue (lock) requests for each type of lock.

Column	Datatype	Description
INST_ID	`NUMBER`	Database instance number
`EQ_TYPE`	`VARCHAR2(2)`	Type of enqueue requested
`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

Another Burleson Consulting information page offers information on Oracle Enqueue Activity Section, which may be helpful in resolving issues concerning the enqueue conversation metric.

This, and many other Oracle performance metrics are discussed in my book "Oracle Tuning" by Rampant TechPress. You can buy it directly from the publisher and save 30% at this link:

http://www.rampant-books.com/book_1002_oracle_tuning_definitive_reference_2nd_ed.htm

��