Compression and Performance in Oracle Database 12 c. Gregg Christman Senior Product Manager – ACO/HCC.
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
Gregg ChristmanSenior Product Manager – ACO/HCC
The preceding is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract.It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.
Introduced in Oracle Database 9i Release 2
Compression during bulk load operations (Direct Load, CTAS)
Data modified using conventional DML not compressed
Optimized compression algorithm for relational data
Customers indicate that typical compression ratio is 2x to 4x
Data is compressed at the database block level
Compression enabled at either the table or partition level
Completely transparent to applications
Flashback Data Archive
Oracle Database Enterprise Edition
2x to 4xCompression Typical
(seconds)Real World Compression Results- ERP Database 10 Largest Tables
10x to 15x Reduction
Optimized for Space
Optimized for Speed on Exadata
Reclaim 93% of Disks
Keep Data Online
Compression and Performance with ACO and SAPMilt Simonds, Director Enterprise Platform Delivery