The following examples show the use and benefits of PowerMax compression and deduplication with Oracle databases. The first example shows the advantages of compression and deduplication of an Oracle database that is not encrypted. The second example shows what happens when the database is fully encrypted. Encryption makes the data appear completely random and interferes with compression benefits.
In both examples, we reported only the Oracle data files’ consumed capacity as reported by the database or storage. The capacity of the redo logs is not reported in the graphs, as it is relatively small.
The examples are based on a SLOB database which was modified so that the data is semi-random. As the example shows, the PowerMax storage system compressed the semi-random database at a 3.1:1 compression ratio, which is approximately the compression ratio that we expect for Oracle databases.