Re: Compression
From: joel garry <joel-garry_at_home.com>
Date: Tue, 15 Dec 2009 08:43:59 -0800 (PST)
Message-ID: <657998e4-faf3-41a6-8872-ea9ca73723f4_at_h14g2000pri.googlegroups.com>
On Dec 15, 2:13 am, gazzag <gar..._at_jamms.org> wrote:
> 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
Date: Tue, 15 Dec 2009 08:43:59 -0800 (PST)
Message-ID: <657998e4-faf3-41a6-8872-ea9ca73723f4_at_h14g2000pri.googlegroups.com>
On Dec 15, 2:13 am, gazzag <gar..._at_jamms.org> wrote:
> 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
Or, cpu queues could lengthen, slowing down latch processing, slowing down SGA operations, slowing down I/O requests, increasing cpu queues...
On my machine, there are a few misbehaving reports that are known to peg a cpu (sometimes thrashing SGA, sometimes in-app memory thrashing). When there is just one, not really a problem. When there are several, sometimes a problem. I wouldn't want to add more cpu load when there is a problem, that would make a real problem. The root problem is management wanting up to the minute DSS reports on an OLTP system. Any db is going to have to deal with that. Isn't the direction of Oracle to put everything into a big db for all purposes?
jg
-- _at_home.com is bogus. http://www.signonsandiego.com/news/2009/dec/15/makeover-family-trying-stave-foreclosure/Received on Tue Dec 15 2009 - 10:43:59 CST