Home > Storage > PowerFlex > White Papers > Oracle RAC Performance on Dell PowerFlex with AMD EPYC Compute Nodes > OLTP workload test
In this test case, the parameter UPDATE_PCT is set to 25 in the slob.conf file resulting in a 25 percent write operations and 75 percent read operations transactional workload. This test case demonstrates that all the reads and writes are serviced from the PowerFlex storage media achieving high IOPS and maintaining relatively low latencies.
The test process on a two node Oracle 21c RAC database includes the following steps:
The following figure shows the AWR IOPS for an OLTP workload for a two node Oracle RAC database. The report shows that on average, the database performance during the test was 460,002 read IOPS and 117,289 write IOPS, for a total of 577,291 IOPS.
Figure 12. AWR showing IOPS for OLTP test case
The following figure shows the Oracle AWR response times for an OLTP workload for a two node Oracle RAC database. The report shows that on average, the data files read response time was 1.02 milliseconds.
Figure 13. AWR showing response time for OLTP test case
The following figure shows the PowerFlex manager performance metrics for an OLTP workload for a two node Oracle RAC database. The Overall performance and Latency metrics from the PowerFlex manager dashboard shows similar IOPS and read response time metrics that are shown in the AWR report.
Figure 14. PowerFlex manager dashboard showing IOPS and latency result for OLTP test case
The following figure shows the PowerFlex manager hosts metrics for an OLTP workload for a two node Oracle RAC database. The read and write IOPS generated from both two node Oracle RAC database servers are similar.
The following figure shows the PowerFlex volume level metrics for an OLTP workload for a two node Oracle RAC database.
The following figure shows the graphical representation of database read and write IOPS that increases with the number of Oracle RAC database instances.