White Papers

15 Sizing and Best Practices for Online Transaction Processing Applications with Oracle 11g R2 using Dell PS Series | BP1003
5 I/O profiling study
The ORION tool uses the Oracle I/O software stack to generate simulated I/O workloads without having to
create an Oracle database, load the application, and simulate users. ORION is commonly used for
benchmarking the I/O performance characteristics of Oracle database storage systems.
A series of ORION tests were executed on PS6010XV, PS6010S, and PS6110XS hybrid arrays for
measuring the storage I/O performance and system limits for pure OLTP workloads.
5.1 PS6010XV array test
The key results from ORION tests executed on the PS6010XV array are shown in Figure 4.
ORION test performance on PS6010XV (15K SAS)
IOPS
Disk latency (ms)
8K IOPS (100% read)
8K IOPS (70/30% R/W)
8K latency (100% read)
8K latency (70/30% R/W)
Increasing queue depth
7,000
6,000
5,000
4,000
3,000
2,000
1,000
0
70
60
50
40
30
20
10
0