Re: Compression
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Tue, 15 Dec 2009 05:37:29 +0000 (UTC)
Message-ID: <hg77ap$5vf$3_at_solani.org>
On Mon, 14 Dec 2009 17:42:53 -0800, hpuxrac 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?
>
> This is covered in the concepts and new features guides for 11g.
Date: Tue, 15 Dec 2009 05:37:29 +0000 (UTC)
Message-ID: <hg77ap$5vf$3_at_solani.org>
On Mon, 14 Dec 2009 17:42:53 -0800, hpuxrac wrote:
> On Dec 14, 2:41 pm, Mladen Gogala <n..._at_email.here.invalid> wrote: > > snip >
>> 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?
>
> This is covered in the concepts and new features guides for 11g.
John, I know this is covered, but the package in question looks like it could give us something on the Oracle 10g. It doesn't. It's an April fool joke. My question wasn't about the Oracle 11g, I know about "COMPRESS FOR ALL OPERATIONS in 11.1 and COMPRESS FOR OLTP in Oracle 11.2. You need an advanced compression license to do that. The URL I pointed you to explains the package that is supposed to run even on Oracle 9i. The page does not explain that the package doesn't really give you anything, that it only provides another interface to the compression that is already in the kernel. The information on that page is definitely misleading.
-- http://mgogala.freehostia.comReceived on Mon Dec 14 2009 - 23:37:29 CST