Anyone use the different types of RMAN compress in 11g ? A Complete Understanding of RMAN Compression (Doc ID 563427.1)
From: Dba DBA <oracledbaquestions_at_gmail.com>
Date: Wed, 9 Nov 2016 13:58:04 -0500
Message-ID: <CAE-dsOK9zas==EzzJEfqe_uC-HBVKYuC6RnUQcrBBDiZOsT6Fw_at_mail.gmail.com>
Anyone know how much more CPU you use and how much space you can save going from Basic to HIGH?
--
http://www.freelists.org/webpage/oracle-l Received on Wed Nov 09 2016 - 19:58:04 CET
Date: Wed, 9 Nov 2016 13:58:04 -0500
Message-ID: <CAE-dsOK9zas==EzzJEfqe_uC-HBVKYuC6RnUQcrBBDiZOsT6Fw_at_mail.gmail.com>
Anyone know how much more CPU you use and how much space you can save going from Basic to HIGH?
SQL> select ALGORITHM_NAME, ALGORITHM_DESCRIPTION, ALGORITHM_COMPATIBILITY from V$RMAN_COMPRESSION_ALGORITHM ;
ALGORITHM_NAME ALGORITHM_DESCRIPTION
ALGORITHM_COMPATIB
BZIP2 good compression ratio
9.2.0.0.0
BASIC good compression ratio
9.2.0.0.0
LOW maximum possible compression speed
11.2.0.0.0
ZLIB balance between speed and compression ratio
11.0.0.0.0
MEDIUM balance between speed and compression ratio
11.0.0.0.0
HIGH maximum possible compression ratio
11.2.0.0.0
--
http://www.freelists.org/webpage/oracle-l Received on Wed Nov 09 2016 - 19:58:04 CET