Return-Path:
Received: from ensim.rackshack.net (root@localhost)
by orafaq.net (8.11.6/8.11.6) with ESMTP id h8Q1nOk08695
for ; Thu, 25 Sep 2003 20:49:24 -0500
X-ClientAddr: 66.27.56.212
Received: from www3.fatcity.com (rrcs-west-66-27-56-212.biz.rr.com [66.27.56.212])
by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id h8Q1nMc08689
for ; Thu, 25 Sep 2003 20:49:22 -0500
Received: (from root@localhost)
by www3.fatcity.com (8.11.6/8.11.6) id h8PNATD10293
for oracle-l@orafaq.net; Thu, 25 Sep 2003 16:10:29 -0700
Received: by fatcity.com (05-Jun-2003/v1.0g-b73/bab) via fatcity.com id 005D1160; Thu, 25 Sep 2003 16:09:40 -0800
Message-ID:
Date: Thu, 25 Sep 2003 16:09:40 -0800
To: Multiple recipients of list ORACLE-L
X-Comment: Oracle RDBMS Community Forum
X-Sender:
Sender: ml-errors@fatcity.com
Reply-To: ORACLE-L@fatcity.com
Errors-To: ML-ERRORS@fatcity.com
From:
Subject: RE: Oracle Compress Option
Organization: Fat City Network Services, San Diego, California
X-ListServer: v1.0g, build 73; ListGuru (c) 1996-2003 Bruce A. Bergman
Precedence: bulk
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: 8bit
Yes please, my email id is avnish.rastogi@providence.org
-----Original Message-----
Sent: Wednesday, September 24, 2003 7: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@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@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@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).
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.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: