Oracle Database Administration, Support, Training and Consulting
What are differences between the regular Oracle compression and the Oracle Advanced Compression?
The key benefits to advanced compression is that is has 2-4X reduction in storage across all environments such as production, standby, test, development, backup, etc. There is improved memory efficiency as data remains compressed in memory. Also minimal or no performance impact on DML operations due to performance optimized compression technology. Queries run faster in many cases, due to improved I/O and memory efficiency. There is better network bandwidth utilization. Transparent to applications - no application changes required. It increases security and reduces the cost of storing and accessing historical data.