HCC (Hybrid Columnar Compression) is appeared only with Exadata but has recently become available to Oracle Databases using ZFS Storage Appliance and Pillar as the database storage. HCC is actually free with Oracle Database Enterprise Edition. No additional database options and no additional ZFS Storage Appliance options are required. HCC requires Oracle Database version 18.104.22.168. To enable HCC in Oracle Databases running on ZFS Storage Appliance, we need to install patch set update of 13343438.
1- Determine whether any currently installed one-off patches conflict with the psu (patch set update) as follows.
opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir ./13343438
Note: Please download correct psu file for your platform (p13343438_11203_.zip)
2- Set your current directory to the directory where the patch is located and then run the OPatch utility as follows.
3- The following step loads modified SQL files into the database. For a RAC environment, perform these steps on only one node. For each database instance running on the Oracle home being patched, connect to the database using SQL*Plus and run the catbundle.sql script as follows.
sqlplus / as sysdba
SQL> @catbundle.sql psu apply
4- Check the following log files for any errors.
5- If you are using the RMAN, the catalog needs to be upgraded. Enter the following command to upgrade catalog.
rman catalog username/password@tns
RMAN> UPGRADE CATALOG;
Now, you can use HCC in Oracle Databases running on Oracle ZFS Storage Appliance.
Talip Hakan Öztürk
One thought on “How To Enable HCC (Hybrid Columnar Compression) in Oracle Databases Running On ZFS Storage Appliance?”