Chatta subito con l'assistenza
Chat con il supporto

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

Cache Miss Rate Alarm

This alarm is raised when the Global Cache Local Miss Rate exceeds a specified threshold. The Cache Miss Rate is the percentage of time that a block required for a logical read is located in an inconsistent mode on ANOTHER instance in the cluster and must be transferred. Possible causes for this alarm are:

  • Hot blocks. A hot block is one that is subject to very high transfer rates and/or latency.
  • Excessive cluster co-ordination activity.

Possible solutions to this problem are:

  • To partition hot tables.
  • To segregate application activity by using services.

 

Related Topics

Related Documents

The document was helpful.

Seleziona valutazione

I easily found the information I needed.

Seleziona valutazione