O'Reilly logo

Expert Oracle RAC Performance Diagnostics and Tuning by Murali Vallath

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

Introduction

Working for several years across several industries on various RAC projects, there have been several occasions to troubleshoot performance issues in a production environment. Applications and databases that where moved from a single-instance Oracle environment to a two or more node RAC environment to hide a performance problem. An example that comes to mind, which I have encountered in the field on several occasions, is when the database was moved to a RAC environment because the single instance was running at 100% CPU and it was hoped that by moving to a RAC configuration, the 100% CPU overload would be distributed between the various instances in the cluster. This really does not happen this way; RAC cannot do magic to fix poorly ...

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