Use Swingbench for stress testing OracleRAC

Test preparation process 1: Set environment variables and import test data. For details, see su

Test preparation process 1: Set environment variables and import test data. For details, see su-Oracle exportPATH =/monitor/agent_12c/core/12.1.0.1.0/jdk.

Test preparation process

1. Set environment variables and import test data. For more information, see the preceding section.

Su-Oracle

ExportPATH =/monitor/agent_12c/core/12.1.0.1.0/jdk/bin/: $ PATH

Export DISPLAY = 10. 6. *. *: 0.0

Cd/monitor/swingbench/bin/

2. Start the coordination Server

./Coordinator-g

3. Start swingbench to configure relevant stress test parameters. exit after the configuration is complete.

4. register three nodes to the registration server Tostart the load generators issue the following commands.

./Minibench-g RAC1-cs10.4. *. *: 1521: tyolap1-co localhost &

./Minibench-g RAC2-cs10.4. *. *: 1521: tyolap2-co localhost &

./Minibench-g RAC3-cs10.4. *. *: 1521: tyolap3-co localhost &

5. Run./clusteroverview for testing.

Stress Test Results

1. When a node is running, the TPMC is about 0.42 million, and the cpu usage reaches 80%-90%. At this time, the database has a large number of logfile sync, PL/SQL lock timer and library cache: mutexX wait events

2, 2 node RAC System