White Paper

Cost and Performance benefits of Dell™ Compellent™ Automated Tiered Storage for Oracle® OLAP

Workloads

Delivers optimal placement of data on each individual disk Figure 5.

Test configuration

A two-node Oracle 11gR2 Real Application Cluster (RAC) was deployed for the database configuration in

this paper. The following hardware and software components were used for the cluster setup.

Hardware and software configurations Table 1.

Component

Details

Servers

Two Dell PowerEdge R720 servers with:

 Two Intel Xeon 8-core 2.20 GHz Processors

 64 GB of RAM

Storage

Dell Compellent SC40 with:

 Two controllers

 One 3.5” SAS enclosure with 12x450GB 15K RPM SAS 3.5” disks

 One 2.5” SAS enclosure with 5x450GB 10K RPM SAS 2.5” disks and

6x1TB 7.2K RPM SAS 2.5” disks

 Storage Center v5.5.3

HBA

8Gb Emulex LPE12002

Network switch

Brocade 5100 for Fiber channel storage connect

Operating system

RHEL 5.7

Oracle software

Oracle 11g R2 11.2.0.3 RAC

Workload

• Quest Benchmark Factory 6.1.1 TPC-H workload

• User connections: One user with 15 Queries