ORAC LE D ATA SHEE T
Oracle Advanced Compression
Oracle Database Advanced Compression provides a comprehensive set of
compression capabilities to maximize storage utilization, reduce costs and
improve performance. Although storage cost savings and optimization across
servers is the most tangible benefit, all of the features with Advanced
Compression are designed to improve performance across components of your
IT infrastructure, including memory, network bandwidth and storage.
K E Y F E AT U R E S
Oracle Advanced Compression
• Reduces database storage
requirements and associated costs Heat Map. Collects data usage information at the block and segment levels – when used
• Typically improves query with Automatic Data Optimization Oracle Database can automate compression and storage
performance
policies based on the usage of the data -- reducing storage costs, improving performance
• Compresses OLTP and data
warehousing application tables and optimizing storage.
• Data in memory remains in Automatic Data Optimization. Enables organizations to create policies that implement
compressed format
compression and storage tiering automatically. ADO policies define conditions and
• Compresses structured, unstructured,
corresponding actions to be applied to specific objects to automate Information Lifecycle
index, backup, network and Data
Guard redo log transport data Management (ILM).
• Heat Map collects segment/block Advanced Row Compression. Enables table data to be compressed during all types of
level data usage information used to
define Automatic Data Optimization data manipulation operations, including DML INSERT and UPDATE operations --
compression and storage tiering intelligent algorithm minimizes compression overhead during write operations, thereby
policies
making compression viable for both data warehouse and OLTP workloads.
• Cascades storage savings
throughout the data center Advanced LOB Compression and Deduplication. Provides compression and
• Reduces the size of all supported deduplication for SecureFiles LOBS. SecureFiles is a high performance, and powerful,
unique and non-unique indexes -- infrastructure for managing unstructured data such as images, documents, videos and
while still providing efficient access to
the indexes more.
• Can be used with any type of Advanced LOB Compression. Compresses unstructured data
application without application Advanced LOB Deduplication. Eliminates duplicate copies of unstructured data
changes
Backup Data Compression. The storage requirements for maintaining database backups
• Reduces the size of the session data
unit (SDU) transmitted over a data and backup performance are directly impacted by database size. Advanced Compression
connection includes compression for backup data when you employ Oracle Recovery Manager
• Reduces the cost of storing and (RMAN) or Oracle Data Pump for database backups.
accessing historical data
Data Guard Redo Transport Compression. Enables the compression of Oracle Data
Guard (primary to standby database) redo data as it is transmitted over the network.
ORAC LE D ATA SHEE T
Advanced Index Compression. Reduces the size of all supported unique and non-unique
indexes- automatically chooses the right compression per index block. Advanced Index
Compression provides significant space savings while also improving performance for
queries that are executed using indexes.
Advanced Network Compression. Compresses network data to be transmitted at the
sending side and then uncompressed at the receiver to reduce the network traffic.
Storage Snapshot Optimization. Using the RECOVER ... SNAPSHOT TIME capability
storage snapshots taken without the database in backup mode can be recovered in one step,
whether to the current time or a specific point-in-time after the snapshot was taken,
without any additional procedures.
Exadata Flash Cache Compression (Exadata only). Dynamically increases the logical
capacity of the flash cache by transparently compressing user data as it is loaded into the
flash cache.
Hybrid Columnar Compression Row Level Locking. Hybrid Columnar Compression
uses one lock per Compression Unit (CU) -- optionally, with Advanced Compression,
users can choose to enable Row Level Locking.
Online Move Table or Partition (to any compressed format). ALTER TABLE ...
MOVE TABLE/PARTITION ONLINE with Advanced Compression enables non-
blocking online DDL where DML operations continue to run uninterrupted on the table, or
partition, being moved to any compressed format (Basic, Advanced Row or Hybrid
Columnar Compression).
Optimization for Flashback Data Archive (FDA) History Table. Enables Flashback
Data Archive to utilize Advanced Row Compression, Advanced LOB
Disclaimer Compression/Deduplication and Compression Tiering -- which are not available by default
The following is intended to outline our general product for Flashback Data Archive history tables.
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.
CONT ACT U S
For more information about Advanced Compression, visit [Link] or call +1.800.ORACLE1 to speak
to an Oracle representative.
C ON N EC T W IT H U S
[Link]/oracle
Copyright © 2019, Oracle and/or its affiliates. All rights reserved. This document is provided for information purposes only, and the
contents hereof are subject to change without notice. This document is not warranted to be error-free, nor subject to any other
[Link]/oracle warranties or conditions, whether expressed orally or implied in law, including implied warranties and conditions of merchantability or
fitness for a particular purpose. We specifically disclaim any liability with respect to this document, and no contractual obligations are
[Link]/oracle formed either directly or indirectly by this document. This document may not be reproduced or transmitted in any form or by any means,
electronic or mechanical, for any purpose, without our prior written permission.
[Link] Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.
Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and
are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are
trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group. 0219
2 | ORACLE ADVANCED COMPRESSION