Oracle 11g Compression of redo

Compression of redo. ( Oracle 11g New Features)

Virag Sharma virag123@gmail.com

Archived redo file can be compressed , while transfering to standby database

alter system set log_archive_dest_1='SERVICE=standby1

compression=ENABLE';

check where there compression is enabled or not

select dest_name , compression from v$archive_dest

compression column will show enable if it is enable.