Chat now with support
Chat with Support

Spotlight on Oracle 10.4 - Getting Started Guide

Welcome to Spotlight Install Spotlight Start Spotlight Spotlight on Oracle Spotlight on Oracle Data Guard Spotlight on Oracle RAC Spotlight on Unix Spotlight on Windows Spotlight on MySQL Troubleshooting: Connection Problems

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