Chapter 23. Optimizing RAC

In this chapter we consider performance tuning techniques that are specific to Real Application Clusters (RAC) databases.

Almost all the tuning measures considered so far are as relevant to a RAC database as to a single-instance (that is, non-RAC) database. Tuning SQL, eliminating contention, memory, and IO optimization are common techniques that are relatively independent of the cluster status of the database. However, RAC does present certain unique performance opportunities and challenges, and we look at these in this chapter.

The key principles in RAC performance management are

• Maintaining high-speed communications between the instances in the cluster

• Eliminating unnecessary inter-instance traffic

• Balancing ...

Get Oracle now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.