Thursday, April 12, 2007

Oracle 11g Compression of redo

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.

2 comments:

  1. This comment has been removed by a blog administrator.

    ReplyDelete
  2. welcome to the wow power leveling, cheap service site,WoW Gold buy cheap wow gold,wow gold,world of warcraft buy wow power leveling

    ReplyDelete

Google