Home > Storage > PowerFlex > White Papers > Oracle RAC Performance on Dell PowerFlex with AMD EPYC Compute Nodes > Read-only workload test
In this test case, the parameter UPDATE_PCT is set to zero in the slob.conf file resulting in a read-only transactional workload. This test case demonstrates that all the reads 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:
For conciseness, only the two-node read-only performance test screenshots are shown. The test results of both single node and two nodes are summarized in Figure 11.
The following figure shows the AWR IOPS for a read-only workload for a two node Oracle RAC database. The report shows that on average, the database performance during the test was 803,882 read IOPS.
The following figure shows the Oracle AWR response times for a read-only workload for a two node Oracle RAC database. The report shows that on average, the data files read response time was 720.47 microseconds (0.72 millisecond).
Figure 8. AWR showing response time for read-only test case
The following figure shows the PowerFlex manager performance metrics for a read-only workload for a two node Oracle RAC database. The overall performance and latency metrics from PowerFlex manager dashboard shows similar IOPS and read response time metrics to the one shown in the AWR report.
Figure 9. PowerFlex manager dashboard showing IOPS and latency result for read-only test case
The following figure shows the PowerFlex volume level metrics for a read-only workload for a two node Oracle RAC database:
The following figure shows the graphical representation of database read IOPS that increases with the number of Oracle RAC database instances, while the average database read response time remained under one millisecond.
Figure 11. Read-only test results for one-node and two-node RAC instances