RE: Compressed tables

Thanks, Waleed! I also found that paper on OTN. It seems to answer my questions.

Thanks again!
Rich

Rich Jesse                           System/Database Administrator
[EMAIL PROTECTED]                  Quad/Tech Inc, Sussex, WI USA

> -----Original Message-----
> From: Khedr, Waleed [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, July 09, 2003 12:27 PM
> To: Jesse, Rich
> Cc: '[EMAIL PROTECTED]'
> Subject: RE: Compressed tables
>
>
> I'm using it for six months now without problems.
>
> I was able to save more than 70% of the used disk space in big data
> warehouse project.
>
> Attached is a pdf paper that might be helpful:
>
> Regards,
>
> Waleed
>
> Any views or opinions presented in this email are solely those of the
> author and do not necessarily represent those of the company
>
> -----Original Message-----
> From: Jesse, Rich [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, July 09, 2003 2:10 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Compressed tables
>
>
> So, there I am, reading about 9iR2's compressed tables feature at:
>
> http://otn.oracle.com/oramag/webcolumns/2003/techarticles/poes
> s_tablecomp.ht
> ml
>
> (wrap URL if necessary, or go to http://tinyurl.com/gg3p )
>
> Other than it being the best thing since sliced bread, what's
> the downside?
> Are there restrictions similar to compressed indexes (e.g. no online
> rebuilds)? How much does CPU usage go up (all
> compression/decompression
> must consume CPU)?
>
> Just curious, really. I have an immediate aversion to any
> product that has
> a term with the initials "CF" and was wondering if compressed
> tables is a CF
> or not.
>
> TIA,
> Rich

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).