White Papers

37 Sizing and Best Practices for Online Transaction Processing Applications with Oracle 11g R2 using Dell PS Series | BP1003
Oracle AWR reports were captured while running these tests and constantly monitored for any RAC or
database related bottlenecks. The top 10 events of the AWR report are shown in Figure 17.
Top 10 events in AWR report
As you can see from the AWR report, the top event is db file sequential read, which means that the disks
were saturated and there were no other bottlenecks related to RAC or database configuration parameters.
6.4 TPC-E on PS6110XS
The PS6110XS arrays consists of 7 x SSDs and 17 x 10K SAS drives. The array has built-in intelligence to
automatically move the data between SSD and SAS tiers within a volume based on the performance
requirements.
The test configuration described in section 6.2.1 used a database of size 1 TB in which the entire database
could fit in the SSDs and consequently, all the I/O activity was handled entirely by the SSDs. The PS6110XS
array produced more than 25,500 IOPS in this scenario.