Mar 12, 2013 3:43:00 PM by Quest Software
|Reducing lock contention|
Lock, or enqueue waits occur when a session waits to obtain a lock. In most cases, this occurs because of a lock on a table or row that the session wants to lock or modify. In some circumstances, the lock involved may be an Oracle internal lock (for instance, the Space Transaction enqueue). If the database is well tuned and the application design sound, enqueue waits should be negligible.
Common causes of excessive enqueue waits are:
Written by Quest Software