Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id h8PGEoX07684 for ; Thu, 25 Sep 2003 11:14:50 -0500 X-ClientAddr: 66.27.56.213 Received: from www2.fatcity.com (rrcs-west-66-27-56-213.biz.rr.com [66.27.56.213]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id h8PGEhc07675 for ; Thu, 25 Sep 2003 11:14:43 -0500 Received: (from root@localhost) by www2.fatcity.com (8.11.6/8.11.6) id h8PDZwm17549 for oracle-l@orafaq.net; Thu, 25 Sep 2003 06:35:58 -0700 Received: by fatcity.com (05-Jun-2003/v1.0g-b73/bab) via fatcity.com id 005D10C3; Thu, 25 Sep 2003 06:34:47 -0800 Message-ID: Date: Thu, 25 Sep 2003 06:34:47 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Khedr, Waleed" Sender: ml-errors@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Khedr, Waleed" 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/mixed; boundary="----=_NextPartTM-000-b0c15d57-8b7a-47e2-9590-00b0aa08fa02" ------=_NextPartTM-000-b0c15d57-8b7a-47e2-9590-00b0aa08fa02 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C38369.62E30A32" ------_=_NextPart_001_01C38369.62E30A32 Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: quoted-printable Something else I forgot, full segment scans becomes faster, since he = segment is 70 percent smaller. So this could help balancing resource utilization between the CPUs and = IO. =20 Waleed -----Original Message----- 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 = cheap. =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 = compress historical data on daily basis and was able to save 70 percent of the = disk 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 = will 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 = table 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 = to 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 ]=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 = 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. >=20 >Thanks=20 ------_=_NextPart_001_01C38369.62E30A32 Content-Type: text/html; charset="ISO-8859-1" RE: Oracle Compress Option
Something else I forgot, full segment scans becomes faster, since he segment is 70 percent smaller.
So this could help balancing resource utilization between the CPUs and IO.
 
Waleed
-----Original Message-----
From: Jamadagni, Rajendra [mailto:Rajendra.Jamadagni@ESPN.COM]
Sent: Thursday, September 25, 2003 9:50 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Oracle Compress Option

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

Disk is not cheap if you pay for high availability configuration. I compress historical data on daily basis and was able to save 70 percent of the disk space. Imagine the amount of savings for five TB.
 
Two major issues:
 
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 will end up with a segment that is not good at all for scattered reads.
 
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 table without compression. So adding many extra columns before compression is a good idea.
 
It's mainly good for data warehouses applications.
 
Regards,
 
Waleed
 
-----Original Message-----
From: Jamadagni, Rajendra [mailto:Rajendra.Jamadagni@espn.com]
Sent: Thursday, September 25, 2003 9:05 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Oracle Compress Option

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 to regular tables due to this export issue. Disk is cheap.

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


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


"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

------_=_NextPart_001_01C38369.62E30A32-- ------=_NextPartTM-000-b0c15d57-8b7a-47e2-9590-00b0aa08fa02-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Khedr, Waleed INET: Waleed.Khedr@FMR.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).