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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.