Troubleshooting

Optimizing an Oracle Database with Dell Compellent Automated Tiered Storage
Page 9
users. The database configuration used in the tests was a 2-node Oracle 11g R2 (11.2.0.3) Real
Application Cluster (RAC). The database schema was populated by Benchmark Factory. The TPC-C test
runs conducted simulated loads from 100 to 3,000 concurrent users in an increment of 100. Test
outputs include metrics such as the average transaction response time and transaction per second
(TPS).
The test configuration consists of the following components:
 PowerEdge R720 servers running Oracle Enterprise Linux 5 Update 7 x86_64, and Oracle 11g R2
Real Application Cluster (RAC) database Enterprise Edition (EE) version 11.2.0.3.0
 Redundant Dell PowerConnect™ Gigabit Ethernet switches for Oracle cluster interconnect
private network
 Server-storage interconnect using redundant Brocade® 5300 Fibre Channel switches
 Redundant Dell Compellent Series 40 controllers
 Dell Compellent SBOD Fibre Channel enclosure populated with 8 SSD drives for tier 1 storage
 Dell Compellent 2.5’’ SAS enclosure populated with 24 15K RPM SAS drives for tier 2 storage
 Dell Compellent 3.5’’ SAS enclosure populated with 12 7K RPM SAS drives for tier 3 storage
An architecture overview of the test configuration is shown in Figure 3.
Figure 3. Configuration architecture of Oracle RAC database and Dell Compellent
storage system
The hardware and software details of the test configuration are summarized in Table 1.