Oracle Advanced Compression


What are differences between the regular Oracle compression and the Oracle Advanced Compression?

Category: asked July 30, 2012

1 Answer


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.