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?