Chat now with support
Chat with Support

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

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.

Select Rating

I easily found the information I needed.

Select Rating