Re: Oracle Compress Option

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
>
>Avnish.Rastogi_at_providence.org 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
>
>
>>
>>
>>
>>
>
>
>

Content-Type: text/plain; name="ReadMe.txt"; charset="us-ascii" Content-Transfer-Encoding: 7bit

The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail.

This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact Postmaster_at_fatcity.com for clarification.

--------------070903060501090708040008--

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
  INET: mln_at_miracleas.dk

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: ListGuru_at_fatcity.com (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).



application/x-zip-compressed attachment: Julian_Dyke_DataSegmentCompression.zip