RE: Compressed tables

From: Jamadagni, Rajendra <Rajendra.Jamadagni_at_espn.com>
Date: Wed, 09 Jul 2003 11:45:55 -0700
Message-ID: <F001.005C4196.20030709113924@fatcity.com>

<FONT face="Courier New" color=#0000ff

size=2>Thanks ... I did achieve about 70+% savings in space ... also one of the thing that Oracle recommends is for greater compression ratio
<FONT face="Courier New" color=#0000ff

size=2> 
<FONT face="Courier New" color=#0000ff

size=2>1. (somehow) load the data sorted ...
<FONT face="Courier New" color=#0000ff

size=2>2. use larger block size if your version (and DBA and technical director and Management and ...) allow it.
<FONT face="Courier New" color=#0000ff

size=2>3. Once you have compressed tables, you may want to use compressed indexes too.
<FONT face="Courier New" color=#0000ff

size=2> 
<FONT face="Courier New" color=#0000ff

size=2>I am still testing this, nowhere near production for us. We find this useful for archival quality data only.
<FONT face="Courier New" color=#0000ff

size=2>Raj
<FONT face="Courier New"

size=2>-------------------------------------------------------------------------------- 

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 !

  <FONT face=Tahoma
  size=2>-----Original Message-----From: Khedr, Waleed   [mailto:[EMAIL PROTECTED]Sent: Wednesday, July 09, 2003 3:24   PMTo: Multiple recipients of list ORACLE-LSubject: RE:   Compressed tables
  <FONT face=Arial color=#0000ff
  size=2>Sorry, I think it's here too: <A   href="http://otn.oracle.com/products/bi/pdf/o9ir2_compression_twp.pdf">http://otn.oracle.com/products/bi/pdf/o9ir2_compression_twp.pdf   <FONT face=Arial color=#0000ff
  size=2> 
  Also
  one of the things I like about it is moving some of the disk IO system   contention to the CPUs when there is extra CPU resources that is not being   utilized.
  <FONT face=Arial color=#0000ff
  size=2> 
  <FONT face=Arial color=#0000ff
  size=2>Waleed   

    <FONT face=Tahoma
    size=2>-----Original Message-----From: Jamadagni, Rajendra     [mailto:[EMAIL PROTECTED]Sent: Wednesday, July 09,     2003 2:35 PMTo: Multiple recipients of list     ORACLE-LSubject: RE: Compressed tables     Waleed,
    the attached paper was compressed by Listguru ... for you,     with good compression ratio too.
    Raj <FONT

    size=2>-------------------------------------------------------------------------------- 

    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 [<A
    href="mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]]     Sent: Wednesday, July 09, 2003 2:25 PM <FONT     size=2>To: Multiple recipients of list ORACLE-L <FONT     size=2>Subject: RE: Compressed tables     I'm using it for six months now without problems. I was able     to save more than 70% of the used disk space in big data warehouse project.     Attached is a pdf paper that might be helpful:     Regards, Waleed   

*********************************************************************This e-mail 

message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank

you.*********************************************************************1

Received on Wed Jul 09 2003 - 13:45:55 CDT