3 Sizing and Best Practices for Online Transaction Processing Applications with Oracle 11g R2 using Dell PS Series | BP1003
Table of contents
Revisions............................................................................................................................................................................. 2
Acknowledgements ............................................................................................................................................................. 2
Executive summary ............................................................................................................................................................. 5
1 Introduction ................................................................................................................................................................... 6
1.1 Objective ............................................................................................................................................................. 6
1.2 Audience ............................................................................................................................................................. 6
1.3 Terminology ........................................................................................................................................................ 7
2 OLTP applications with PS Series arrays .................................................................................................................... 8
2.1 PS Series hybrid arrays ...................................................................................................................................... 8
3 Solution infrastructure .................................................................................................................................................. 9
3.1 Physical system test configuration ..................................................................................................................... 9
3.2 Storage configuration ....................................................................................................................................... 10
3.3 Database layout ................................................................................................................................................ 11
4 Test methodology ....................................................................................................................................................... 13
4.1 Measurement and monitoring ........................................................................................................................... 13
4.2 Test criteria ....................................................................................................................................................... 14
5 I/O profiling study........................................................................................................................................................ 15
5.1 PS6010XV array test ........................................................................................................................................ 15
5.2 PS6010S array test .......................................................................................................................................... 16
5.3 PS6110XS hybrid array test ............................................................................................................................. 17
5.3.1 ORION (1 TB array capacity utilization, 100% random I/O and no data locality) ............................................. 18
5.3.2 ORION (2 TB array capacity utilization, 100% random I/O and no data locality) ............................................. 20
5.3.3 ORION (4 TB array capacity utilization, 100% random I/O and no data locality) ............................................. 21
5.3.4 Vdbench (2 TB array capacity utilization, 100% random I/O and 20% data locality) ....................................... 23
5.3.5 Number of volumes studies .............................................................................................................................. 24
5.3.6 Oracle ASM and non-ASM environments ........................................................................................................ 26
5.4 ORION/Vdbench on PS6110XS ....................................................................................................................... 27
6 OLTP performance studies using TPC-E like workload ............................................................................................. 28
6.1 Oracle memory management study ................................................................................................................. 28
6.2 TPC-E (array capacity utilization study) ........................................................................................................... 31
6.2.1 1 TB array capacity utilization ........................................................................................................................... 31
6.2.2 4 TB array capacity utilization ........................................................................................................................... 33