Re: Anyone use the different types of RMAN compress in 11g ? A Complete Understanding of RMAN Compression (Doc ID 563427.1)

have you checked this (not so old) thread already? http://www.freelists.org/post/oracle-l/11gR2-rman-compression-algorithms

hth
 Martin

2016-11-09 20:04 GMT+01:00 Chris Taylor <christopherdtaylor1994_at_gmail.com>:

> I don't know the answer but there are licensing implications for some of
> those:
>
> "As of 11g, Oracle introduced the zlib algorithms that enhance
> compression and reduce CPU utilization. If you are using one of the zlib
> compression algorithms with RMAN, then you need to license Advanced
> Compression."
> http://houseofbrick.com/oracle-licensing-and-the-
> advanced-compression-option/
>
> Chris
>
>
> On Wed, Nov 9, 2016 at 12:58 PM, Dba DBA <oracledbaquestions_at_gmail.com>
> wrote:
>
>> 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
>>
>>
>>

--
http://www.freelists.org/webpage/oracle-l