Home > Storage > PowerFlex > White Papers > Dell APEX Block Storage for AWS: Oracle Database Deployment and Performance > OLTP workload test scenario and test results
Setting UPDATE_PCT to nonzero in the slob.conf file results in an OLTP workload that is a mix of database read and write operations. The OLTP workload test was conducted with a 75/25 read/write ratio with one Amazon EC2 instance running an Oracle single instance database, and by gradually increasing the number of Amazon EC2 and Oracle database instances distributed across multiple AZs.
Gradually increase the number of Oracle single instance databases and the number of concurrent users.
Each Oracle single instance database is built with 256 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 256 schemas with an 8 GB scale yields 2 TB of total test data.
The test process includes the following steps:
The following table shows the results of the 75/25 read/write workload where the database read/write IOPS increases with the scaling of the Oracle single instance databases.
Metrics | 1 x Oracle DB | 2 x Oracle DBs | 3 x Oracle DBs | 4 x Oracle DBs |
Database write IO requests | 60,457 | 121,254 | 174,406 | 205,843 |
Database read IO requests | 243,211 | 486,856 | 701,244 | 826,555 |
Total database read/write IO requests | 303,668 | 608,110 | 875,650 | 1,032,398 |
DB file read latency (millisecond) | 0.92 | 0.93 | 0.96 | 1.1 |
Note: The metrics are taken from the Oracle database statistics report (AWR). They signify the actual performance metrics that the database experienced relative to storage IOPS and latencies.
Figure 10 shows PowerFlex performance metrics for OLTP 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 11 shows the OLTP workload database IOPS with the scaling of Amazon EC2 instances running Oracle single instance databases on Dell APEX Block Storage for AWS, while the average database read response time remains under one millisecond. A total of 1,032,398 database read/write IOPS, and an average database read latency of 1.1 milliseconds with the four databases in Dell APEX Block Storage for AWS when using Amazon instance store (NVMe SSD).
Figure 11. Read/Write (OLTP) scalability results using Amazon instance store (NVMe SSD)