Re: Oracle Compression

From: Mark Bole <makbo_at_pacbell.net>
Date: Thu, 31 Mar 2005 21:26:37 GMT
Message-ID: <hWZ2e.5292$FN4.123@newssvr21.news.prodigy.com>

yuvalyuval wrote:

> Hi,
>
> I would like to compress some Oracle tables to see how well they can
> compress. Is there some sort of a guide or rules for how well tables
> can compress based on their datatypes? I know that some of our DBA's
> have managed to compress tables up to 70%.
>
> What tables if any shouldn't be compressed? Are there datatypes that
> compresses better or is it block related only?
>
> I would like to understand and decide which tables should be compressed
> without testing each table.
>
> Thanks,
>
> Yuval
>

Make sure you understand the difference between key compression of an IOT, data segment compression, and the UTL_COMPRESS package in 10g. They're all three different things, with different uses and implications.

-Mark Bole Received on Thu Mar 31 2005 - 15:26:37 CST