EnqTimeouts (EnqTimeouts)

The EnqueueTimeouts parameter shows the number of times an enqueue lock was requested but was not granted immediately during the last hourly reporting interval.

Recommendations

If there is a contention on enqueue resources, increase the init.ora enqueue_resources parameter

When setting the enqueue_resources parameter, allow one process per resource, regardless of the number of sessions or cursors using the resource, not one per lock.

Use the following table to select the appropriate value for enqueue_resources:

If init.ora processes value is...	Set enqueue_resources default value to...
3 or less	20
between 4 and 10	[(processes - 3) * 5] + 20
greater than 10	[(processes - 10) * 2] + 55

Do not assign enqueue_resources a value greater than the sum of the init.ora parameters (dml_locks + ddl_locks).
If you want to monitor contention, consider changing the thresholds to alarm when an enqueue timeout occurs.

BMC PATROL properties

Attribute	Default value
Application class	ORACLE_PERFORMANCE
Command type	Not applicable
Platform	All
Icon style	Graph
Unit	Number of timeouts
Border range	Undefined
Alarm1 range	Undefined
Alarm2 range	Undefined
Scheduling(poll time)	Poll time of collector
Active at installation	Yes
Parameter type	Consumer
Value set by	CollPerformance

BMC ProactiveNet Performance Management properties

Property	Default value
Monitor type	Oracle Database Performance
Key Performance Indicator	Yes
Monitor for abnormalities	No
Graph by default	Yes
Availability	No
Response time	No
Normal distribution	Yes
Statistical	Yes