Oracle Advanced Compression

Oracle Advanced Compression provides a comprehensive set of compression capabilities to help improve performance and reduce storage costs. It allows organizations to reduce their overall database storage footprint by enabling compression for all types of data: relational (table), unstructured (file), network, Data Guard Redo and backup data. Although storage cost savings and optimization across servers (production, development, QA, test, backup and etc...) are often seen as the most tangible benefits, additional innovative technologies included in Oracle Advanced Compression are designed to improve performance and to reduce CapEx and OpEx costs for all components of an IT infrastructure, including memory and network bandwidth as well as heating, cooling and floor-space costs.

Free Download
Download Oracle Database 11g Download
Compression Advisor

Learn More about Compression Advisor

Key Benefits

  • Typically 2x-4x reduction in storage across all environments such as production, standby, test, development, backup, etc.
  • Improved memory efficiency as data remains compressed in memory
  • Heat Map stores system-generated data access statistics at the row and segment levels
  • Automatic Data Optimization (ADO) enables organizations to set policies that enforce data compression/movement automatically
  • Minimal or no performance impact on DML operations due to performance optimized compression technology
  • Faster queries in many cases, due to improved I/O and memory efficiency
  • Compresses network data at the sending side and then uncompressed at the receiver to reduce the network traffic
  • Better Data Guard Redo transport network bandwidth utilization
  • Transparent to applications - no application changes required
  • Increases security and reduces the cost of storing and accessing historical data

Technical Information

red-arrow-box Oracle Advanced Compression Helps Global Fortune 500 Company Meet Storage Savings Initiative PDF
red-arrow-box Oracle Advanced Compression with Oracle Database 12c (White Paper) PDF
red-arrow-box Oracle Advanced Compression (Data Sheet)  PDF
red-arrow-box Advanced Compression Video (5 minutes) Video
red-arrow-box Advanced Compression Case Studies
red-arrow-box Compression of Unstructured Data - SecureFiles White Paper PDF
red-arrow-box Backup Compression - Data Pump White Paper PDF
red-arrow-box VARCHAR and SecureFiles CLOB: A Comparative Analysis PDF

Advanced Compression and Applications

red-arrow-box Optimizing Storage for Oracle Siebel Applications PDF
red-arrow-box Optimizing Storage for Oracle PeopleSoft Applications PDF
red-arrow-box Optimizing Storage for Oracle E-Business Suite Applications PDF
red-arrow-box Advanced Compression 11gR1 Benchmarks with EBS 12 PDF
red-arrow-box Optimizing Storage in SAP with Oracle Database 11g Release 2 PDF
red-arrow-box Advanced Metering Infrastructure Performance SAP White Paper (SAP on Oracle Database 11g Release 2 with Advanced Compression) PDF

Free Download

red-arrow-box Download Compression Advisor
red-arrow-box Learn more about Compression Advisor

Oracle Store

red-arrow-box Buy Oracle Advanced Compression online at the Oracle Store

Document References

red-arrow-box Advanced Row Compression
red-arrow-box Advanced LOB Compression
red-arrow-box RMAN Compression
red-arrow-box Data Pump Compression
red-arrow-box Advanced Network Compression
red-arrow-box Data Guard Redo Compression


red-arrow-box Advanced Compression - Frequently Asked Questions


red-arrow-box Computerworld Advanced Compression Article
red-arrow-box Compress to Impress (Oracle Magazine Article)
red-arrow-box SecureFiles: Oracle Database 11g Top New Feature

Customer Podcast

red-arrow-box TVS Motor Company runs SAP on Oracle Database 11g
red-arrow-box Sharp HealthCare
red-arrow-box Bank of America
red-arrow-box Heidelberg - Sven Lareum
red-arrow-box Land-o-Lakes
red-arrow-box MetLife - Margaret Maglione
red-arrow-box MetLife - Asha Santosh
red-arrow-box Wellcome Trust Sanger Institute's Green Initiative use of Oracle Database 12c Storage Optimization - Karen Ambrose
red-arrow-box AmerisourceBergen - Milt Simonds
red-arrow-box Large Financial Institution

Customer Case Study

red-arrow-box Oracle Advanced Compression Helps Global Fortune 500 Company Meet Storage Savings Initiative
red-arrow-box Enel Italy and Heidelberger AG Customer Case Studies (ACO with SAP -- Please see pages 64 and 68 respectively)
red-arrow-box Sharp and TVS Motors Customer Case Studies (ACO with SAP -- Please see pages 50 and 54 respectively)
red-arrow-box Sharp HealthCare
red-arrow-box CSX Corporation

Discussion Forums/Blogs

red-arrow-box Advanced Compression
red-arrow-box Oracle Database
red-arrow-box Database Storage Optimization Blog

Related Technologies

red-arrow-box Temporal Database Funtionality
red-arrow-box Oracle SecureFiles
red-arrow-box Oracle Recovery Manager
red-arrow-box Oracle Data Pump
red-arrow-box Oracle Data Guard
red-arrow-box Information Lifecycle Management
red-arrow-box Hybrid Columnar Compression
red-arrow-box Index Key Compression
red-arrow-box Bitmap Indexes


In-Memory Replay Banner