Oracle RAC Design Considerations

The best applications, database designs, and coding practices that are applicable to a single-instance Oracle database are also applicable to Oracle RAC. A well-tuned application in a single-instance environment on a symmetric multiprocessing (SMP) machine should run well in an Oracle RAC environment.

If an application has capacity issues, moving to the Oracle RAC environment will not solve them; at best it will provide some temporary relief until the basic design or code issues are fixed; at worst, it may actually degrade performance because Oracle RAC may amplify an existing performance flaw. So is there anything you can do to make an application run better in an Oracle RAC environment? The following sections ...

Get Oracle Database 11g Oracle Real Application Clusters Handbook, 2nd Edition, 2nd Edition now with O’Reilly online learning.

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