Home > Storage > PowerFlex > White Papers > Dell APEX Block Storage for AWS: Oracle Database Deployment and Performance > Read-only workload test scenario and test results
Let's get started by adding your files.
Click on the green button to begin.
In this test, the parameter UPDATE_PCT is set to zero in the slob.conf file resulting in a read-only transactional workload. This test starts with one Amazon EC2 instance running an Oracle single instance database and gradually increasing the number of Amazon EC2 instances, each running its own Oracle single instance database. The same number of storage instances used are same in all the tests and are distributed across multiple availability zones.
In the Oracle database scalability test, gradually increase the number of Oracle single instance databases and the number of concurrent users.
Each Oracle single instance database is built with 128 SLOB schemas, each with an 8 GB dataset. The size of each schema is controlled by the scale parameter in the slob.conf file. The 128 schemas with 8 GB scale yields 1 TB of total test data.
The test process includes the following steps:
The following table shows the results of the read-only workload where the workload increased with the scaling of the Oracle single instance databases:
Table 5. Scaling of Oracle single instance databases and resulting IOPS increase
Metrics | 1 x Oracle database | 2 x Oracle databases | 3 x Oracle databases | 4 x Oracle databases |
Database read I/O requests | 59,876 | 120,243 | 179,341 | 235,314 |
DB file read latency (millisecond) | 0.98 | 0.98 | 0.98 | 1 |
Figure 12 shows PowerFlex performance metrics for read only workload for four Oracle single instance databases run simultaneously on Dell APEX Block Storage for AWS. The overall performance and latency metrics from the PowerFlex manager dashboard shows similar IOPS and read response time metrics to those shown in the Oracle AWR report.
Figure 12. PowerFlex manager showing read-only workload metrics for Amazon EBS volumes
Figure 13 shows that the database read IOPS increased with the number of Oracle single instance databases, while the average database read response time remains under one millisecond. A total of 235,314 read IOPS and an average database read latency of 1 millisecond with the four databases when using Dell APEX Block Storage for AWS. The IOPS increased linearly with each additional database instance added into the Dell APEX Block Storage for AWS. The metrics are taken from the Oracle database statistics report (AWR) and signify the actual performance metrics the database experienced relative to IOPS and latencies.
Figure 13. Read-only scalability results using Amazon EBS volumes