This Ready Solutions for Oracle Design for Unity All-Flash Unified Storage provides simple, easy-to-use management by allowing storage administrators to provision storage with very little setup or planning. This architecture provides predictable and consistent performance and data savings for every environment in a typical enterprise application.
This validated and tested reference architecture enables the upgrading of Oracle Database 12cR2 to 18cR1 without performance degradation, providing faster time-to-value, operational agility, and efficiency.
An examination of AWR reports of the 18cR1 database and the 12cR2 database from which it was upgraded reveals that there was minimal performance impact after adding snapshots and running stress testing. Further, the deduplication and compression features of the Unity 650 All Flash storage array provided significant storage capacity savings and reduced TCO.
In this reference architecture guide, we have demonstrated the ease of upgrading the Oracle Database 12cR2 to the Oracle Database 18cR1. The IOPS numbers exceeded 100,000 in all the use cases, with better results in the testing of the 18c database. We noted a consistent pattern in database server CPU utilization, which ranged between 26 and 28 percent for all the use cases. Database response time was consistently at approximately 0.31 ms. TPS and bandwidth were improved in the 18cR1 database test results as compared to the 12cR2 database test results. Finally, running either Oracle Database 12cR2 or 18cR1 on the Unity 650F array provided notable data compression rates.
If customers elect to upgrade their Oracle Database 12cR2 to Oracle Database 18cR1 on Dell EMC products like the PowerEdge Server R840, Unity 650F All-Flash Storage, and Dell EMC networking products, there will be no adverse impact on database performance, and performance may actually improve. In summary, here are the key results from our testing of this Ready Solutions for Oracle: