Choose a topic
Oracle Advanced Compression Oracle Advanced Compression provides comprehensive data compression capabilities to compress all types of data, backups, and network traffic in an application transparent manner. With Advanced Compression, Oracle includes table compression targeted at OLTP workloads, resulting in reduced storage consumption and improved query performance while incurring minimal write performance overhead. Advanced Compression can be used to compress any unstructured content using SecureFiles Compression. Deduplication provides the ability to automatically eliminate redundant copies of SecureFiles data. RMAN offers multiple backup compression levels, to meet the needs of various environments, including faster compression and better compression ratio choices. Note that the RMAN DEFAULT COMPRESS option does not require Advanced Compression. With Advanced Compression, Data Pump exports can now be compressed to reduce disk space requirements. Note that the COMPRESSION=METADATA_ONLY option for Data Pump does not require Advanced Compression, and is the default behavior. Finally, Data Guard can compress redo data resulting in reduced network traffic and faster gap resolution.The Oracle Advanced Compression option contains the following features:Data Guard Network CompressionData Pump Compression (COMPRESSION=METADATA_ONLY does not require the Advanced Compression option)Multiple RMAN Compression Levels (RMAN DEFAULT COMPRESS does not require the Advanced Compression option)OLTP Table CompressionSecureFiles Compression and DeduplicationFlashback Data Archive (formerly known as Total Recall)For releases earlier than Oracle Database 11g Release 2 (220.127.116.11): You must license the Oracle Advanced Compression option to use Flashback Data Archive.Beginning with Oracle Database 11g Release 2 (18.104.22.168): Flashback Data Archive—without history table optimization—is available in all editions.Optimization for Flashback Data Archive history tables. Available starting with Oracle Database 11g Release 2 (22.214.171.124).Exadata Flash Cache Compression: This feature can be enabled only on Exadata storage servers, and all database processors that access the Exadata storage servers must be licensed for Oracle Advanced Compression.
Oracle Advanced Compression