Chat now with support
Chat with Support

Spotlight on Oracle 10.7 - 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

Row Cache Objects Latch Wait Alarm

The row cache objects latch protects the contents of the row cache; the section of the shared pool to cache dictionary information.

Causes of contention:

  • High rates of DDL associated with the recursive SQL that maintains internal Oracle information such as space management and undo management.
  • Other potential causes are many and varied. Track down the root cause of the problem by identifying the SQL concerned or the areas of the row cache associated with the contention.

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating