Jump to Navigation

287 - Oracle Advanced Compression

Advanced Compression provides storage reduction through compression of all data types. It also provides performance improvements in several cases
as compressed blocks result in more data being moved per I/O. It further improves memory efficiency as Oracle Database keeps data compressed in memory.
All these benefits cascade through all the environments such as staging, QA, development, standby, backup, etc., magnifying the benefits several times.
Advanced Compression includes enhanced compression capabilities for backups and also helps in faster synchronization of databases
using Data Guard during gap resolution process.

alter table <owner>.<table_name > compress for all operations move;

Example :

select OWNER,TABLE_NAME,COMPRESSION,COMPRESS_FOR from dba_tables where COMPRESSION='DISABLED' and TEMPORARY='N';

select OWNER,TABLE_NAME,COMPRESSION,COMPRESS_FOR from dba_tables where TABLE_NAME='MYTABLE01';

Compression :
1. DISABLEED   
2. ENABLED

You can compress  an Index as well.

alter index <index name> rebuild compress;

 

 



Main menu 2

Story | by Dr. Radut