Methodology - Expert Oracle RAC Performance Diagnostics and Tuning - page 16

RAP Testing
Migration from a single instance to a RAC configuration should be for the right reasons, namely, scalability of the
enterprise systems and availability. Scalability is achieved through optimal performance of the application code,
and availability is achieved by redundant components of the hardware configuration. Both these reasons should
be thoroughly tested from end to end for optimal performance and stability of the environment. Methodologies we
discussed in the previous sections are just guidelines to have a systematic approach to testing and tuning the system;
the actual tests and plans will have to prepared and customized based on the environment, O/S, number of nodes
in the cluster, storage components, and the workload of the application. Testing should cover three major areas of
RAC: recovery, availability, and performance (RAP). In this section, we discuss the various phases of RAP testing. Just
like the acronym, the tests have been grouped together into three primary groups: availability, recoverability, and
scalability (see Figure 1-5 ).

Node 1 Node 2 Node 3 Node 4 Node 5 Node 6

SSKY_1 SSKY_2 SSKY_3 SSKY_4 SSKY_5 SSKY_6

AV6 AV7 AV8 AV9 AV10 AV11 AV12 AV13 AV14 AV15 AV16 AV17 AV18

GRID_DATA PRD_DATA PRD_FRA

Recoverability

Figure 1-5. RAP testing