Oracle Advanced Compression Option for v9.x

Categories:
Solution Number:
S30512
Last Modified:
2017-05-03
Issue
You or your DBA may have noticed that some Oracle tables for v9 has advanced compression enabled:

OWNER TABLE_NAME COMPRESSION 
------------ ------------------------------ -------- 
ATERNITY HIS_SUBLOC_CTX_COMBO_FLAT_TBL ENABLED 
ATERNITY HIS_SUBLOC_EP_COMBO_FLAT_TBL ENABLED 
ATERNITY HIS_LOCSER_CTX_COMBO_FLAT_TBL ENABLED 
ATERNITY BREADCRUMB ENABLED 
ATERNITY HISTORICAL_CTX_COMBO_FLAT_TBL ENABLED 
ATERNITY COMMON_AGGREGATE_PLUS_LOG ENABLED 
ATERNITY COMMON_AGGREGATE_PLUS_SETUP ENABLED 
ATERNITY HISTORICAL_EP_COMBO_FLAT_TBL ENABLED 
ATERNITY HIS_LOCSER_EP_COMBO_FLAT_TBL ENABLED 

Is Oracle's Advanced Compression Option (ACO) required for v9.x and can it be disabled? What about if our Oracle license does not include the use of this feature?
Solution
Yes, ACO is a required feature for v9 to work properly and cannot be disabled.

The OEM Oracle license that is included with the purchase of Aternity allows for the use of this feature. The licensed version of Oracle that comes with Aternity is called Database Enterprise Edition, with Partitioning and Advanced compression. Please note that it is only allowed for use with Aternity and no other applications.
Environment
This applies to platform v9.x and Oracle 11g & 12c
Attachments
NOTICE: Riverbed® product names have changed. Please refer to the Product List for a complete list of product names.
Can't find an answer? Create a case