O'Reilly logo

Oracle by Guy Harrison

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required