Chat now with support
Chat with Support

Spotlight on Oracle 10.5 - Release Notes

Lock Wait Alarm

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.

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating