Chatta subito con l'assistenza
Chat con il supporto

Spotlight on Oracle 10.10 - 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 Troubleshooting: Connection Problems

Result Cache Latch Sleep Ratio Alarm

Spotlight raises the Result Cache Latch Sleep Ratio alarm when:

  • The rate of latch sleeps for the Result Cache latch is a high percentage of the rate of latch sleeps for all latches, and
  • The total time taken by the Latch Wait event exceeds 2% of the total database time.

This indicates that there is contention on the Result Cache latch, where multiple processes are competing to use the latch and are causing a significant degradation in response time.

To reduce contention on the Result Cache latch, consider reducing the number of result sets added to the cache:

  • View the SQL & Application Workload | Result Cache |Contents Page to find statements that can be excluded from the cache via Result Cache Parameters and Hints.
  • Reduce the size of the result cache to exclude result sets that are too large.

 

Related Documents

The document was helpful.

Seleziona valutazione

I easily found the information I needed.

Seleziona valutazione