Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: compress/compact database?

Re: compress/compact database?

From: Sergey Adamenko <adamenko_at_i.com.ua>
Date: Thu, 2 May 2002 18:08:35 +0300
Message-ID: <aarks6$2eeo$1@news.dg.net.ua> 





If your datafiles are stored on NTFS partition under NT/W2000, you can set
'Compressed' attribute for your datafiles.
I do so when working with some of my testing DB: Oracle work pretty good.
But there is performance cost you would pay when  intensive
WRITE-to-datafiles operations will occure. Later this  will cause
considerable fragmentation on  the OS partiotion.



Best regards,


Sergey Adamenko
Received on Thu May 02 2002 - 10:08:35 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US