RE: Export - Compress

I don't believe that good answer is meant for this particular question.

The COMPRESS option on the EXPort command does not compress any data. When the option is set then it tweaks the DDL that is created in the export file so that the objects are created in a single extent, when imported.

I doubt you would notice a performance difference with either Y or N.

At this point, your probably thinking about using an OS utility to compress the export dump file, which is where the other answer will be applicable.

HTH Chris Grabowy
"May Oracle be with you...always"

-----Original Message-----
From: I.S. Manager [mailto:ismgr_at_pctc.com] Sent: Monday, July 31, 2000 12:09 PM
To: Multiple recipients of list ORACLE-L Subject: Re: Export - Compress

That would be very system-dependant. Compression is highly cpu-intensive. If you have the system to yourself, that won't be a bottleneck, but on a busy system, it could slow things down.
With compression off, you require more disk i/o. But if your disk controller has lots of buffering, this may not be a bottleneck. Basically, the answer is non-deterministic, and the only way to find out is to test in your environment.

At 07:16 AM 7/31/00 -0800, you wrote:
>Hi,
>
>Small question :
>
>Which is fastest, an export with Compress = Y or an export with Compress =
N
>???
>

---
Dennis Taylor
---
The opinions expressed herein are mine. Get your own opinions!
---
-- 
Author: I.S. Manager
  INET: ismgr_at_pctc.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_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).