White Papers

18 Sizing and Best Practices for Online Transaction Processing Applications with Oracle 11g R2 using Dell PS Series | BP1003
The results collected from these tests are illustrated in sections 5.3.1 to 5.3.4. Additional I/O simulation tests
were run to evaluate Oracle ASM benefits and also to determine the volume configuration which produces
optimal performance. These test results are discussed in sections 5.3.5 and 5.3.6.
5.3.1 ORION (1 TB array capacity utilization, 100% random I/O and no data locality)
ORION tests were run with a range of user loads on 2 x 500 GB volumes. The total capacity utilized on the
array was 1 TB and the I/O access was completely random in nature (100% random without any specific
locality of I/O access).
This test on the array produced approximately 17,000 IOPS for an 8K block size with a 70/30% read/write mix
workload while staying within the generally accepted disk latency limit of 20 ms (for both read and write IOPS
measured separately).
IOPS and latency reported by SAN HQ (1 TB capacity utilization and no data locality)
Because the total capacity of volumes was 1 TB, the seven SSDs were able to handle all the I/O activity and
there was not much activity on 10K SAS drives.