Home > Workload Solutions > Oracle > White Papers > Dell PowerMax 2500 and 8500 Best Practices for Mission Critical Oracle Databases > Single database workload with SLs
Figure 4 shows the effect of SLs on a single Oracle database workload. In this test, SLOB workload runs without interruption or change. Only the SL of the PDB (OraRAC_DB_data SG) is changed every 30 minutes.
Figure 4 shows that a Bronze SL forced an average of 5 millisecond latency, which resulted in 16,000 IOPS. After the SL changed to Silver, the latency dropped to 2 millisecond and IOPS increased to 38,000. The Gold SL reduced latency to 0.6 millisecond and IOPS increased to 112,000. The Platinum and Diamond SLs both performed at 0.2 millisecond latency and approximately 190,000 IOPS.
When SL changes, the effect is immediate because it takes place at the PowerMaxOS software layer. SL latencies affect both reads and writes I/O response times.