Advanced Row Compression | Used for structured data |
Advanced LOB Deduplication and Compression | Used for unstructered data |
Advanced Index Compression | |
RMAN and Data Pump compression | Database backups |
Advanced Network Compression | Compression of data transferred between database and application. |
Data Guard redo log transport Compression | Network |
dbms_redefinition
alter table … move row store compress advanced
alter table … row store compress advanced
(only data of future DML is compressed) dbms_compression
(also referred to as compression advisor).