Andrew Holdsworth, Director of Real World Performance for Oracle Corporation, identifies three factors that often contribute to problems in building large Oracle systems:
Getting the application design wrong
Not understanding the technology
Insufficient or irrelevant testing
In this chapter, we look at the concepts behind the third of these identified factors; specifically, we will examine how to test a RAC configuration and make the testing count by stressing the right components in the stack. We will first introduce benchmarking and load testing, and establish the goals that load tests should set out to achieve. Second, we will look at interpreting the RAC benchmarks officially published by Oracle in conjunction ...