Re: Compression
Date: Mon, 14 Dec 2009 22:57:30 +0000 (UTC)
Message-ID: <pan.2009.12.14.22.57.30_at_email.here.invalid>
On Mon, 14 Dec 2009 19:41:16 +0000, Mladen Gogala wrote:
> The word "compression" is very fashionable these days. I find that
> strange because everybody keeps telling me how cheap disks are these
> days and yet, there is a slew of compression algorithms all around: MP3,
> MPEG-2,OGG, ZIP, BZIP2, GZIP, everything is compressed to save the
> inexpensive and cheap disk space. Oracle seems to have noticed the
> fashion so they have released a package which should produce the 11.2
> behavior. The package is called "Oracle Advanced Compression Advisor"
> and is described here:
>
> http://www.oracle.com/technology/products/database/compression/
> compression-advisor.html
>
> Has anybody played with that? Is there any possibility of compressing
> the table for OLTP or ("ALL OPERATIONS" in 11.1) in Oracle 10g?
>
> I thought of compressing this message to make it more in and
> fashionable, but the unfortunate effect would be that the message would
> be somewhat less readable. This message will, however, self-destruct in
> 5 minutes after reading.
This is an April's fool joke:
SQL> set serveroutput on
SQL> exec dbms_comp_advisor.getratio('NEWS','NEWS_PROGRAMS','OLTP',10);
Invalid Compression option for the current COMPAT setting
PL/SQL procedure successfully completed. SQL> show parameter compat
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------ compatible string 10.2.0.4 plsql_v2_compatibility boolean FALSESQL> SQL> select * from v$version;
BANNER
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Prod PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for Linux: Version 10.2.0.4.0 - Production NLSRTL Version 10.2.0.4.0 - Production
This doesn't give me anything. This is funny, to have my database vendor joking with me. I wonder what else there might be a joke?
-- http://mgogala.byethost5.comReceived on Mon Dec 14 2009 - 16:57:30 CST