Advanced Compression Option for Data Pump and License

Posted in Oracle Data Pump, Uncategorized by

Oracle Advanced Compression

Oracle Advanced Compression provides comprehensive data compression and Information Lifecycle Management (ILM) capabilities for all types of data: structured/unstructured, backup, network, archive, and Data Guard Redo Transport traffic. To facilitate automated ILM, Heat Map and Automatic Data Optimization enable organizations to maintain system-generated data usage statistics, at the row and segment levels, and to set policies that implement data compression/movement automatically.

Advanced Compression is an option that you have to pay for when you are using it.

The Oracle Advanced Compression option contains the following features:

  • Advanced Row Compression
  • Advanced LOB Compression
  • Advanced LOB Deduplication
  • RMAN Backup Compression (RMANDEFAULT COMPRESS does not require the Advanced Compression option)
  • Data Pump Data Compression (COMPRESSION=METADATA_ONLYdoes not require the 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).

Data Pump Compression Feature

DBAs cannot always control the use of Advance Compression options. For Instance, Using COMPRESSION=METADATA_ONLY (which is default) option in expdp does not require the Advanced Compression option, however COMPRESSION=ALL option required advance compression option. There is no way to avoid the usage without revoking right to use data pump at all.

License

Bug 8478082 : DISALLOW UNLICENSED COMPRESSION FEATURE WHILE USING DATA PUMP

There is no way to disable the use of any of the features that are part of the Advanced Compression option. You can track the usage of those features with DBA_FEATURE_USAGE_STATISTICS, and if you discover a feature is being used when it shouldn’t be, you can contact the user and ask them to stop using it.

 

***

Leave a comment