RE: Table compression
- From: "Goulet, Dick" <DGoulet@xxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 19 Mar 2004 15:52:25 -0500
Yeah, but what's the penalty during reads???
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----
From: Khedr, Waleed [mailto:Waleed.Khedr@xxxxxxx]
Sent: Friday, March 19, 2004 3:48 PM
To: 'oracle-l@xxxxxxxxxxxxx'
Subject: RE: Table compression
I use it, works great, 60% savings.
Once the table/partition gets flagged "compress", any direct load will be
compressed.
You will get ora-600 if trying to do parallel direct load.
Also can't add a column to a compressed table.
Waleed
-----Original Message-----
From: LeRoy Kemnitz [mailto:lkemnitz@xxxxxxxx]
Sent: Friday, March 19, 2004 3:41 PM
To: Oracle List
Subject: Table compression
I am looking into doing some table compression on my warehouse database
to free up some space on the os. I am running 9.2.0.4 on Unix 5.1. The
compression is about 2.5:1 on my tables. The documentation says the
bulk insert time will be doubled but the single inserts, updates, and
deletes are going to be a wash. Does anyone use compression? Are there
any problems you notice in the use of it? I have also read that the
table will need to be re-compressed after the bulk inserts. Any
alternative ideas about getting this done?
Thanks in advance,
LeRoy
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
