Compression

Q: Is Hybrid Columnar Compression supported for Oracle Enterprise Edition?

A: Yes, the MODS Regular platform supports HCC with these algorithms:

Query Low suitable for Data Warehouse
Query High suitable for Data Warehouse
Archive High suitable for Archive
Archive Low suitable for Archive

Example query to create a compressed tablespace for Archive Low:

CREATE BIGFILE TABLESPACE "TS_DATA_HCC_01" 
DATAFILE SIZE 200m AUTOEXTEND ON NEXT 10m MAXSIZE 100G
LOGGING ONLINE permanent BLOCKSIZE 8192 EXTENT MANAGEMENT LOCAL AUTOALLOCATE DEFAULT TABLE COMPRESS FOR ARCHIVE LOW INDEX COMPRESS
ADVANCED LOW SEGMENT SPACE MANAGEMENT AUTO;

Note: Creating HCC compressed tablespaces and tables is only enabled for these PDB_LOCKDOWN profiles:

default
jvm
network

Q: Can we combine encryption and compression?

A: Yes.

Example query to create a compressed and encrypted tablespace:

CREATE BIGFILE TABLESPACE "TS_DATA_HCC_ENC_01"
DATAFILE SIZE 10m AUTOEXTEND ON NEXT 10m MAXSIZE 100M
LOGGING ONLINE PERMANENT BLOCKSIZE 8192 EXTENT MANAGEMENT LOCAL AUTOALLOCATE
ENCRYPTION USING 'AES128' ENCRYPT DEFAULT TABLE COMPRESS FOR ARCHIVE LOW INDEX COMPRESS ADVANCED LOW SEGMENT SPACE MANAGEMENT AUTO;

Q: Where do I get more Information about using HCC on MODS Regular Platform?

A: Read this Technical Whitepaper - Implementing Hybrid Columnar Compression on the Oracle ZFS Storage Applianceopen in new window.

# Compression

Compression