The preceding chapter describes the performance and capacity saving studies of Oracle Database 12cR2 on the Unity 650F storage array. This chapter focuses on similar studies of Oracle Database 18cR1. We upgraded Oracle Database 12cR2 to 18cR1, conducted the same performance and capacity-saving studies, and compared the results. Because we upgraded the previously used Oracle Database 12cR2, both the 12c and 18c test databases shared the same data and the same configuration of the entire stack, from the storage to the ESXi host/guest VM operating system and the Oracle database. Through the same set of use cases as described in Chapter 3, we can compare the performance and capacity savings on the Unity 650F storage array before and after upgrading the 12c database to 18c.
To achieve these objectives, we first upgraded the 12cR2 database to 18cR1 as shown in the following figure.
Figure 17. Upgrading Oracle Database 12c to 18c