White Papers

10 Sizing and Best Practices for Online Transaction Processing Applications with Oracle 11g R2 using Dell PS Series | BP1003
The logical test configuration diagram for OLTP database application tests (TPC-E) using Quest Benchmark
Factory is shown in Figure 2.
TPC-E test configuration — LAN and iSCSI SAN connectivity
3.2 Storage configuration
The database files, REDO logs, and system-related table spaces such as SYSTEM and UNDO were stored
on PS6110XS and PS6010XV arrays in their own pool called Database pool. The flashback recovery and
archive data was stored on a PS6XXXE array consisting of high-capacity SATA drives which was in a
separate pool named Backup pool. To enable advanced MPIO functionality, the PS Series Host Integration
Tools for Linux (HIT/Linux) were installed on the RHEL server. The default connection parameters of two
iSCSI sessions per volume slice on an array and a maximum of six iSCSI sessions for the entire volume were
used. Also, the default load balancing policy and I/Os per path were used for the MPIO. The utility eqltune,
installed as part of the HIT/Linux package, was run and its OS parameter recommendations were
implemented.
Refer to appendix A for configuration details.