Oracle-L: RE: Oracle Compress Option

From: <Reginald.W.Bailey_at_jpmorgan.com>
Date: Thu, 25 Sep 2003 13:54:47 -0800
Message-ID: <F001.005D114D.20030925135447@fatcity.com>

IF it is not too much trouble, could you e-mail me a copy of the article Mogens?

Thank you.

Reginald W. Bailey
IBM Global Services - ETS SW GDSD - Database Management Your Friendly Neighborhood DBA
713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager) reginald.w.bailey_at_jpmorgan.com
baileyre_at_us.ibm.com

                                                                                                                             
                    ChrisStephens@                                                                                           
                    affina.com           To:     ORACLE-L_at_fatcity.com                                                        
                    Sent by:             cc:                                                                                 
                    ml-errors_at_fatc       Subject:     RE: Oracle Compress Option                                             
                    ity.com                                                                                                  
                                                                                                                             
                                                                                                                             
                    09/25/2003                                                                                               
                    03:54 PM                                                                                                 
                    Please respond                                                                                           
                    to ORACLE-L

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
>
>

--
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Chris Stephens
  INET: ChrisStephens_at_affina.com

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).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: Reginald.W.Bailey_at_jpmorgan.com

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).

Received on Thu Sep 25 2003 - 16:54:47 CDT