Oracle Advanced Compression provides database-compression capabilities that improve performance while reducing storage costs. Oracle Advanced Compression reduces an organization’s overall database storage footprint for all types of data—relational (table), unstructured (file), index, Data Guard redo, network, and RMAN backups—and also improves performance for all components of the database infrastructure, including memory and network bandwidth.
Use Oracle Advanced Compression to achieve at least a 2X reduction in overall database storage—with little or no disruption during implementation.
Reduce the total application database data size to better use existing database storage and lower growth in the future.
Building compression into the database allows Oracle Database to read compressed data and indexes directly in memory.
Oracle Database compression has no adverse impact on read operations, and the database’s buffer cache becomes more efficient by storing more data without adding memory.
Compressed data remains compressed during RMAN backups and does not need to be uncompressed before recovery—reducing backup storage needs, and potentially backup and restore times.
Oracle Advanced Compression provides three levels of RMAN Backup Compression: Low, Medium, and High. The amount of storage savings increases from Low to High, and typically uses fewer CPU resources than RMAN Basic Compression.
Advanced Network Compression, also referred to as SQL Network Data Compression, compresses network data during transmission to reduce network traffic.
Data Guard Redo Transport Services transfers redo data to standby site(s). Redo data is compressed with Oracle Advanced Compression, then transmitted in compressed form. This reduces both network bandwidth consumption and the transmission time of redo data.
Oracle Database compression is built into the database, and application changes are not required to run Oracle Advanced Compression.
Organizations use Oracle Advanced Compression to efficiently manage data growth, minimizing database storage-related costs while continuing to achieve the highest levels of application query performance.
With 100% application transparency application and SQL changes are not needed to use Oracle Advanced Compression with COTS applications.
Robust compression and improved query performance are key benefits for any size of custom OLTP or data warehouse application.
Data lifecycle management enables organizations to understand their data access over time and optimize their database compression and database storage tiering based on their current data usage.
See how Yapı Kredi Bank reduced data lifecycle management administration time and costs with Oracle Advanced Compression.
Use Oracle Compression Advisor for free.
Review compression proof-of-concept insights and best practices.
Interested in learning more? Contact one of our industry-leading experts.