Re: Oracle Compress Option

[Mogens Nørgaard]

Not at all, Chris - here you go.

Chris Stephens wrote:

Hey Mogens...

Would you mind sending me a copy of that paper?

Thanks either way!!

chris

-----Original Message-----
Sent: Wednesday, September 24, 2003 9:05 PM
To: Multiple recipients of list ORACLE-L

"Compress to impress?" by Julian Dyke is a good presentation on this topic (see for instance http://www.ukoug.org/calendar/jan03/jan30ab.htm).

I do have the article - 202 K with no compression, 147 K with compression :).

Let me know if you're interested, and I'll email it directly to you.

Mogens

[EMAIL PROTECTED] wrote:

Does anybody has any experience with Oracle 9I compression option. I did

some test on 9202 with a table of more 14 million rows. Table has total 7
indexes. Surprising both table and indexes are using more space after
compression. Before compression space used is 13064MB and after compression
13184MB. In both the cases I did export from source table and stored in two
different tablespaces. Any insight on that and any disadvantages of using
that.

Thanks



DISCLAIMER:
This message is intended for the sole use of the individual to whom it is

addressed, and may contain information that is privileged, confidential and
exempt from disclosure under applicable law. If you are not the addressee
you are hereby notified that you may not use, copy, disclose, or distribute
to anyone the message or any information contained in the message. If you
have received this message in error, please immediately advise the sender by
reply email and delete this
message.vhttp://www.ukoug.org/calendar/jan03/jan30ab.htm

Julian Dyke DataSegmentCompression.zip
Description: Zip compressed data