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@xxxxxxxxx>
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
--
//www.freelists.org/webpage/oracle-l