Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id h8PG58f06821 for ; Thu, 25 Sep 2003 11:05:08 -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 h8PG4Ic06703 for ; Thu, 25 Sep 2003 11:04:21 -0500 Received: (from root@localhost) by www3.fatcity.com (8.11.6/8.11.6) id h8PDPUt31344 for oracle-l@orafaq.net; Thu, 25 Sep 2003 06:25:30 -0700 Received: by fatcity.com (05-Jun-2003/v1.0g-b73/bab) via fatcity.com id 005D10C1; Thu, 25 Sep 2003 06:24:42 -0800 Message-ID: Date: Thu, 25 Sep 2003 06:24:42 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Mladen Gogala" Sender: ml-errors@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Mladen Gogala" 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: multipart/alternative; boundary="----=_NextPart_000_0024_01C38346.AA336470" ------=_NextPart_000_0024_01C38346.AA336470 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I agree: disk is cheap, as long as I don't have to pay for it. =20 =20 -- Mladen Gogala Oracle DBA=20 -----Original Message----- Jamadagni, Rajendra Sent: Thursday, September 25, 2003 9:50 AM To: Multiple recipients of list ORACLE-L Waleed, I get your point ...=20 =20 We have 6 RAC instances that run active-active ... and compared to availability requirements, we (incl management) decided that disk is chea= p. =20 I guess it is relative ... =20 Raj -------------------------------------------------------------------------= --- ----=20 Rajendra dot Jamadagni at nospamespn dot com=20 All Views expressed in this email are strictly personal.=20 QOTD: Any clod can have facts, having an opinion is an art !=20 -----Original Message----- Sent: Thursday, September 25, 2003 9:35 AM To: Multiple recipients of list ORACLE-L Disk is not cheap if you pay for high availability configuration. I compr= ess historical data on daily basis and was able to save 70 percent of the dis= k space. Imagine the amount of savings for five TB. =20 Two major issues: =20 1) Oracle says updates will be slow on compressed tables, but I say don't= even try to update a compressed table, uncompress first otherwise you wil= l end up with a segment that is not good at all for scattered reads. =20 2) You can not add columns to the table when it's compressed, so if you compressed a big table and need a new column you need to recreate the tab= le without compression. So adding many extra columns before compression is a= good idea. =20 It's mainly good for data warehouses applications. =20 Regards, =20 Waleed =20 -----Original Message----- Sent: Thursday, September 25, 2003 9:05 AM To: Multiple recipients of list ORACLE-L I think 9202 doesn't like to export compressed tables in direct mode ... = so watch out for that ... I implemented, tested and next day reverted back t= o regular tables due to this export issue. Disk is cheap. A BAARF party member wannabe !!=20 Raj=20 -------------------------------------------------------------------------= --- ----=20 Rajendra dot Jamadagni at nospamespn dot com=20 All Views expressed in this email are strictly personal.=20 QOTD: Any clod can have facts, having an opinion is an art !=20 -----Original Message-----=20 Sent: Wednesday, September 24, 2003 10:05 PM=20 To: Multiple recipients of list ORACLE-L=20 "Compress to impress?" by Julian Dyke is a good presentation on this=20 topic (see for instance http://www.ukoug.org/calendar/jan03/jan30ab.htm).= =20 I do have the article - 202 K with no compression, 147 K with=20 compression :).=20 Let me know if you're interested, and I'll email it directly to you.=20 Mogens=20 Avnish.Rastogi@providence.org wrote:=20 >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 compressi= on 13184MB. In both the cases I did export from source table and stored in t= wo different tablespaces. Any insight on that and any disadvantages of using= that. >=20 >Thanks=20 Note: This message is for the named person's use only. It may contain confiden= tial, proprietary or legally privileged information. No confidentiality = or privilege is waived or lost by any mistransmission. If you receive th= is message in error, please immediately delete it and all copies of it fr= om your system, destroy any hard copies of it and notify the sender. You= =20must not, directly or indirectly, use, disclose, distribute, print, or= =20copy any part of this message if you are not the intended recipient. W= ang Trading LLC and any of its subsidiaries each reserve the right to mon= itor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, e= xcept where the message states otherwise and the sender is authorized to = state them to be the views of any such entity. ------=_NextPart_000_0024_01C38346.AA336470 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Message
I=20 agree: disk is cheap, as long as I don't have to pay for it.
 
 
--
Mladen Gogala
Oracle DBA
=20
=20
-----Original Message-----
From:=20 =20 ml-errors@fatcity.com [mailto:ml-errors@fatcity.com] On Behalf Of = =20 Jamadagni, Rajendra
Sent: Thursday, September 25, 2003 = 9:50=20 =20 AM
To: Multiple recipients of list ORACLE-L
Subject:<= /B> RE:=20 =20 Oracle Compress Option

=20
Waleed, I get your point ...
=20
 
=20
We have 6 RAC instances that run active-active ... and compa= red to=20 =20 availability requirements, we (incl management) decided that disk is = =20 cheap.
=20
 
=20
I guess it is relative ...
=20
 
=20
Raj
=20
------------------------------------------------------------= --------------------=20 =20
Rajendra dot Jamadagni at nos= pamespn dot=20 =20 com
All Views expresse= d in this=20 =20 email are strictly personal.
QOTD:=20 =20 Any clod can have facts, having an opinion is an art !
=20
=20
-----Original Message-----
From: Khedr, Waleed=20 =20 [mailto:Waleed.Khedr@FMR.COM]
Sent: Thursday, September 2= 5, 2003=20 =20 9:35 AM
To: Multiple recipients of list=20 =20 ORACLE-L
Subject: RE: Oracle Compress Option

=20
Disk is not=20 =20 cheap if you pay for high availability configuration. I compress hi= storical=20 =20 data on daily basis and was able to save 70 percent of the disk spa= ce.=20 =20 Imagine the amount of savings for five TB.
=20
 
=20
Two major=20 =20 issues:
=20
 
=20
1) Oracle=20 =20 says updates will be slow on compressed tables, but I say don't eve= n try to=20 =20 update a compressed table, uncompress first otherwise you will end = up with a=20 =20 segment that is not good at all for scattered reads.<= /DIV> =20
 
=20
2) You can=20 =20 not add columns to the table when it's compressed, so if you compre= ssed a=20 =20 big table and need a new column you need to recreate the table with= out=20 =20 compression. So adding many extra columns before compression is a g= ood=20 =20 idea.
=20
 
=20
It's mainly=20 =20 good for data warehouses applications.
=20
 
=20
Regards,
=20
 
=20
Waleed
=20
 
=20
=20
-----Original Message-----
From: Jamadagni, Ra= jendra=20 =20 [mailto:Rajendra.Jamadagni@espn.com]
Sent: Thursday, Se= ptember=20 =20 25, 2003 9:05 AM
To: Multiple recipients of list=20 =20 ORACLE-L
Subject: RE: Oracle Compress=20 Option

=20

I think 9202 doesn't like to export compressed = tables in=20 =20 direct mode ... so watch out for that ... I implemented, tested a= nd next=20 =20 day reverted back to regular tables due to this export issue. Dis= k is=20 =20 cheap.

=20

A BAARF party member wannabe !!
Raj
--------------------------------------------------------= ------------------------=20 =20
Rajendra dot Jamadagni at nospamespn dot com=20 =20
All Views expressed in this email are strictly= =20 =20 personal.
QOTD: Any clod can have facts= , having an=20 =20 opinion is an art !


=20

-----Original Message-----
From:=20 =20 Mogens N=F8rgaard [mailto:mln@miracleas.dk]=20 =20
Sent: Wednesday, September 24, 2003 10:05 PM=20 =20
To: Multiple recipients of list ORACLE-L
Subject: Re: Oracle Compress Option


=20

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

=20

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

=20

Let me know if you're interested, and I'll emai= l it=20 =20 directly to you.

=20

Mogens

=20

Avnish.Rastogi@providence.org wrote: =20

>Does anybody has any experience with Oracle= =209I=20 =20 compression option. I did some test on 9202 with a table of more = 14=20 =20 million rows. Table has total 7 indexes. Surprising both table an= d indexes=20 =20 are using more space after compression. Before compression space = used is=20 =20 13064MB and after compression 13184MB. In both the cases I did ex= port from=20 =20 source table and stored in two different tablespaces. Any insight= =20on that=20 =20 and any disadvantages of using that.

=20

>
>Thanks=20 =20

 
Note:
This message is for the named person's use only.  It may contai= n=20 confidential, proprietary or legally privileged information.  No=20 confidentiality or privilege is waived or lost by any mistransmission.&nb= sp; If=20 you receive this message in error, please immediately delete it and = all=20 copies of it from your system, destroy any hard copies of it and notify t= he=20 sender.  You must not, directly or indirectly, use, disclose, distri= bute,=20 print, or copy any part of this message if you are not the intended=20 recipient. Wang Trading=20 LLC and any of its subsidiaries each reserve the rig= ht to=20 monitor all e-mail communications through its networks.  Any views=20 expressed in this message are those of the individual sender, except wher= e the=20 message states otherwise and the sender is authorized to state them to be= =20the=20 views of any such entity.
 
 
------=_NextPart_000_0024_01C38346.AA336470-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: mladen@wangtrading.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@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).