On Wed, 2002-11-20 at 13:48, Rushforth, Tim wrote: > We tend to get 90 % compression for a lot of our Oracle data. So 10 GB may > shrink to 1 GB. Give it a try to see what compression rate you get.
It depends upon how full the allocated space for Oracle is. You can have a 50GB abc.dbf file with 50MB of data on it. *That* sucker'll compress way down. Its 50GB neightbor xyz.dbf with 48GB of data on it won't compress much at all. -- -- Mark Stapleton ([EMAIL PROTECTED]) Certified TSM consultant Certified AIX system engineer MCSE