Using "compress=y" means only that the value of the "initial" storage parameter written to the "create" DDL statement in the .dmp file gets set to the value of "select sum(bytes) from dba_extents where owner=:v1 and segment_name=:v2".
"compress=y" is a wretched, awful thing for a number of reasons, not the least of which is that it causes imports to fail if you have a segment that's bigger than your OS-restricted maximum file size. The parameter is poorly named because it causes no space savings whatsoever. To the contrary, using "compress=y" preserves whatever wasted space has accumulated during the segment's history. Because of the parameter's misleading name, many people attribute temporary performance gains after using exp and then imp to the "compress=y" setting, but you'll actually get identical performance gains by using "compress=n". DBAs should almost always use "compress=n" instead of allowing the default "compress=y" to change their extent sizes. Better yet, DBAs should use uniform extent sizes with their locally managed tablespaces and avoid the "compress=y|n" problem entirely. � Cary Millsap Hotsos Enterprises, Ltd. [EMAIL PROTECTED] http://www.hotsos.com -----Original Message----- Shirley Sent: Thursday, May 16, 2002 10:44 AM To: Multiple recipients of list ORACLE-L Doesn't it mean that all rows are compressed into 1 extent? -----Original Message----- Sent: Thursday, May 16, 2002 12:08 PM To: Multiple recipients of list ORACLE-L Subject: RE: Compressing Export Dumps / WinZip I don't know whether this is a tangent, but I notice that on the windows platform, "compressed" exports can still get 85% compression when zipping them with WinZip. Obviously Oracle "compressed=y" doesn't mean "compress the export file", it just means that it places all the segments contiguously in the export file. Right? Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & Operations | Admin. et Exploit. des syst�mes Technology Services | Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | R�gion des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Taylor, Shirley INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cary Millsap INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
