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

Load Imbalance Alarm

The Load Imbalance alarm is raised when:

  • The load across instances in the Oracle RAC cluster is significantly unbalanced, and
  • The imbalance is proven to be statistically significant, beyond a 95% probability.

Possible causes for this alarm are:

  • A mismatch in hardware configuration.
  • Poor configuration of client-side TNS files.
  • Design or implementation flaws in the Oracle load-balancing algorithms.
  • Large batch jobs concentrated on individual nodes in the cluster.

To solve cluster balance problems:

  • Rectify any detected hardware configuration problems.
  • Improve the load-balancing configuration in client-side TNS files (or elsewhere).
  • Balance or schedule batch jobs across nodes.

Note: To select the metric used to represent cluster balance, see Cluster Balance Metric.

Filters on the Load Imbalance alarm

Spotlight can suppress the Load Imbalance alarm in situations where an unbalanced workload does not represent a problem.

  • When the load is not significant.
  • When required Oracle services cause the imbalance. When a user assigns a non-default Oracle service to a specific instance in the cluster, the extra load may cause some imbalance. Spotlight considers this imbalance significant only when:
    • OS monitoring is on.
    • At least one instance is showing 100% CPU load (averaged over 5 samples).
    • At least one instance is showing less than 80% CPU load (averaged over 5 samples).


Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating