Tchater maintenant avec le support
Tchattez avec un ingénieur du 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

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.

 

Documents connexes

The document was helpful.

Sélectionner une évaluation

I easily found the information I needed.

Sélectionner une évaluation