Home > Storage > PowerFlex > White Papers > Oracle RAC Performance on Dell PowerFlex with AMD EPYC Compute Nodes > Sequential I/O read workload test
The SLOB configuration consisted of 64 users (also database schemas, or tables), with a scale of 20 GB and SCAN_TABLE_SZ of 19 GB for a total dataset size of 2.4 TB. Together with Oracle system and undo tablespaces, the +DATA ASM disk group was close to 3 TB of capacity used.
In this test case, the sequential I/O read workload can be generated using the following parameters UPDATE_PCT=0 and SCAN_PCT=100 in the slob.conf file resulting in full table scan workloads that require as much bandwidth as they can get.
The test process on a three node Oracle 21c RAC database includes the following steps:
The following figure shows the AWR bandwidth for sequential I/O read workload for three node Oracle RAC database. The report shows that on average, the database performance during the test was 15,421 MB (15.42 GB) reads per second.
The following figure shows the Oracle AWR response times for sequential I/O read workload for three node Oracle RAC database. The report shows that on average, the data files read response time was 176 microseconds (0.176 millisecond).
Figure 19. AWR showing response time for sequential I/O workload
The following figure shows PowerFlex manager performance metrics for sequential I/O read workload for three node Oracle RAC database. The Overall performance and Latency metrics from PowerFlex manager dashboard shows similar bandwidth and read response time metrics shown in the AWR report.
The following figure shows PowerFlex monitoring volume level metrics for sequential I/O read workload for three node Oracle RAC database. The below figure shows approximately 4 GB/s bandwidth generated per volume to a total of 16 GB/s bandwidth for four volumes.
The following figure shows the graphical representation of database bandwidth that increases with the number of Oracle RAC database instances.