Embedded Files
This is a cost option
Advanced Compression Option Status
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.1NOTE 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 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
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)
Page updated
Google Sites
Report abuse