Advanced Compression Option

This is a cost option

Advanced Compression Option Status

Is AC installed?

SELECT value

FROM v$option

WHERE parameter = 'Advanced Compression';

Is AC used?

sqlplus / as sysdba @/u01/dba/scripts/options_packs_usage_statistics.sql

If this script does not exist, download it from MOS Note: 1317265.1
NOTE that Oracle internal usage of features does not constitute a license breach. If you install the SYSMAN schema (for OEM) then this script may report a false positive due to the fact that the SYSMAN schema has a couple of tables where compression is enabled. See Bug 11902142 and Note 1309070.1 for full details.
NOTE that Oracle RMAN BZIP2 Compression does not need the Advanced Compression Option although the DBA_FEATURE_USAGE_STATISTICS view may report this incorrectly. See Bug 16088534 and Note 1309070.1 for full details.
NOTE You may get false positives on usage of Advanced Index Compression. See Bug 16088534 (and Bug 24844549 if you are using HCC - requires Exadata, ZFS, or Pillar Axiom 600) and Note 1309070.1 for full details.
NOTE You may get false positives for HeapCompression prior to 12.1.0.2. See 16859747 and Note 1309070.1 for full details.
NOTE You may get false positives for Hybrid Columnar Compression (HCC). You can only be using HCC if you have Exadata, ZFS, or Pillar Axiom 600 storage. See Bug 21248059 and Note 1309070.1 for full details.

Advanced Compression Option Features

  • Advanced Row Compression

  • Advanced LOB Compression

  • Advanced LOB Deduplication

  • RMAN Backup Compression (RMAN DEFAULT COMPRESS does not require the Oracle Advanced Compression option)

  • Data Pump Export Data Compression (COMPRESSION=METADATA_ONLY does not require the Oracle Advanced Compression option)

  • Heat Map

  • Automatic Data Optimization

  • Data Guard Redo Transport Compression

  • Advanced Network Compression

  • Optimization for Flashback Data Archive History Tables

  • Storage Snapshot Optimization

  • Online Move Partition (to any compressed format)

  • Exadata Flash Cache Compression (This feature can be enabled only on Exadata storage servers, and all database processors that access the Exadata storage servers must be licensed for Oracle Advanced Compression.)

  • Advanced Index Compression

  • Hybrid Columnar Compression Row-Level Locking (Requires Exadata, Supercluster, ZFS, or FS1 storage)

Bibliography


https://docs.oracle.com/en/database/oracle/oracle-database/12.2/dblic/Licensing-Information.htmlhttps://oracle-base.com/articles/misc/tracking-database-feature-usageDatabase Options/Management Packs Usage Reporting for Oracle Databases 11gR2, 12c, 12cR2 and 18c (Doc ID 1317265.1)Place Holder For Feature Usage Tracking Bugs (Doc ID 1309070.1)