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

Get Expert Oracle RAC Performance Diagnostics and Tuning 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.