Re: Compression
From: gazzag <gareth_at_jamms.org>
Date: Tue, 15 Dec 2009 02:13:21 -0800 (PST)
Message-ID: <21c6946b-bfa4-4835-8f30-9e962f37d4cf_at_y24g2000yqb.googlegroups.com>
On 14 Dec, 19:41, Mladen Gogala <n..._at_email.here.invalid> 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.
>
> --http://mgogala.byethost5.com
Date: Tue, 15 Dec 2009 02:13:21 -0800 (PST)
Message-ID: <21c6946b-bfa4-4835-8f30-9e962f37d4cf_at_y24g2000yqb.googlegroups.com>
On 14 Dec, 19:41, Mladen Gogala <n..._at_email.here.invalid> 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.
>
> --http://mgogala.byethost5.com
I don't believe that compression is simply about saving "cheap" disk space as it used to be. Now that CPUs are so much more powerful, data can be uncompressed very quickly in memory reducing disk I/O.
-g Received on Tue Dec 15 2009 - 04:13:21 CST