White Paper

Cost and Performance benefits of Dell™ Compellent™ Automated Tiered Storage for Oracle® OLAP
Workloads
10
Component
Details
Volume
Configuration
3 X OCRVOTE - 2GB
Control files - 3GB
Online Redo log - 4GB
DATA - 700GB
FRA - 700GB
The architecture overview of the test configuration is shown in Figure 6
Test configuration architecture Figure 6.
Test methodology
To observe the performance and cost benefits of Dell Compellent Automated Tiering Storage for an
Oracle OLAP workload, various tests were performed by database solution engineers using Quest
Software Benchmark Factory TPC-H, a load-generating utility that simulates OLAP workload on a
database. Initially the tests were conducted on single storage tier to get the baseline numbers. Then
the engineers enabled each of the Dell Compellent storage features like Fast Track, Data Instant