Get Live Help
The Lock Wait alarm occurs when the proportion of time spent waiting for locks exceeds a threshold.
Lock waits can occur for a number of reasons, sometimes including internal database contention. However, the most common category of locks are those taken out on table rows or index entries during an update, insert, or delete.
For more information about the locks on the system, see the Activity | Blocking Locks Page. For more information about reducing lock overhead, see Reduce Lock Contention.