以下在11.2.0.3上，2 cores+ext3文件系统， 导出schema下10G数据，使用compression+ parallel=2 ，耗时大越10分钟， 生成的dump文件总共4.7GB大小
[oracle@mlab1 ~]$ expdp dumpfile=HDUMP:bcm%U.dmp filesize=2048M compression=all schemas=bcm parallel=2 logfile=HDUMP:bcm.log Export: Release 11.2.0.3.0 - Production on Wed Sep 26 11:56:19 2012Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.Username: / as sysdbaConnected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit ProductionWith the Partitioning, Automatic Storage Management, OLAP, Data Miningand Real Application Testing optionsStarting "SYS"."SYS_EXPORT_SCHEMA_01": /******** AS SYSDBA dumpfile=HDUMP:bcm%U.dmp filesize=2048M compression=all schemas=bcm parallel=2 logfile=HDUMP:bcm.log Estimate in progress using BLOCKS method...Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATATotal estimation using BLOCKS method: 10.82 GBProcessing object type SCHEMA_EXPORT/USERProcessing object type SCHEMA_EXPORT/SYSTEM_GRANTProcessing object type SCHEMA_EXPORT/ROLE_GRANTProcessing object type SCHEMA_EXPORT/DEFAULT_ROLEProcessing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMAProcessing object type SCHEMA_EXPORT/TABLE/TABLEProcessing object type SCHEMA_EXPORT/PROCEDURE/PROCEDUREProcessing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDUREProcessing object type SCHEMA_EXPORT/TABLE/INDEX/INDEXProcessing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINTProcessing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS. . exported "BCM"."C_CUSTOMER" 1.194 GB 3000000 rows. . exported "BCM"."C_STOCK" 2.311 GB 10000000 rows. . exported "BCM"."C_ORDER_LINE" 809.8 MB 30004095 rows. . exported "BCM"."E_TRADE" 81.05 MB 4419000 rows. . exported "BCM"."E_SETTLEMENT" 19.90 MB 4590000 rows. . exported "BCM"."E_CASH_TRANSACTION" 32.58 MB 4383000 rows. . exported "BCM"."E_DAILY_MARKET" 33.43 MB 3861000 rows. . exported "BCM"."C_HISTORY" 56.62 MB 3000115 rows. . exported "BCM"."E_TRADE_HISTORY" 6.042 MB 4481000 rows. . exported "BCM"."C_ORDER" 15.22 MB 3000128 rows. . exported "BCM"."E_WATCH_ITEM" 17.15 MB 4414000 rows. . exported "BCM"."E_FINANCIAL" 40.82 MB 1000000 rows. . exported "BCM"."E_ACCOUNT_PERMISSION" 9.659 MB 710000 rows. . exported "BCM"."E_NEWS_ITEM" 1.133 MB 100000 rows. . exported "BCM"."E_CUSTOMER" 3.526 MB 100000 rows. . exported "BCM"."E_ADDRESS" 1.731 MB 150000 rows. . exported "BCM"."E_COMPANY" 826.3 KB 50000 rows. . exported "BCM"."C_DISTRICT" 67.51 KB 1000 rows. . exported "BCM"."C_ITEM" 5.609 MB 100000 rows. . exported "BCM"."E_CUSTOMER_ACCOUNT" 6.697 MB 500000 rows. . exported "BCM"."C_WAREHOUSE" 12.47 KB 100 rows. . exported "BCM"."E_BROKER" 9.898 KB 1000 rows. . exported "BCM"."E_CHARGE" 4.968 KB 15 rows. . exported "BCM"."E_COMMISSION_RATE" 5.937 KB 240 rows. . exported "BCM"."E_COMPANY_COMPETITOR" 703.2 KB 150000 rows. . exported "BCM"."C_NEW_ORDER" 744.1 KB 900088 rows. . exported "BCM"."E_EXCHANGE" 5.468 KB 4 rows. . exported "BCM"."E_INDUSTRY" 6.460 KB 102 rows. . exported "BCM"."E_CUSTOMER_TAXRATE" 413.0 KB 200000 rows. . exported "BCM"."E_NEWS_XREF" 471.7 KB 100000 rows. . exported "BCM"."E_LAST_TRADE" 485.3 KB 68500 rows. . exported "BCM"."E_SECTOR" 5.039 KB 12 rows. . exported "BCM"."E_STATUS_TYPE" 4.867 KB 5 rows. . exported "BCM"."E_TAXRATE" 8.703 KB 320 rows. . exported "BCM"."E_TRADE_TYPE" 5.062 KB 5 rows. . exported "BCM"."E_SECURITY" 2.177 MB 68500 rows. . exported "BCM"."E_WATCH_LIST" 252.6 KB 100000 rows. . exported "BCM"."E_HOLDING" 0 KB 0 rows. . exported "BCM"."E_HOLDING_HISTORY" 0 KB 0 rows. . exported "BCM"."E_HOLDING_SUMMARY" 0 KB 0 rows. . exported "BCM"."E_TRADE_REQUEST" 0 KB 0 rows. . exported "BCM"."E_ZIP_CODE" 103.3 KB 14741 rowsMaster table "SYS"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded******************************************************************************Dump file set for SYS.SYS_EXPORT_SCHEMA_01 is: /home/oracle/dump/bcm01.dmp /home/oracle/dump/bcm02.dmp /home/oracle/dump/bcm03.dmp /home/oracle/dump/bcm04.dmpJob "SYS"."SYS_EXPORT_SCHEMA_01" successfully completed at 12:05:03[oracle@mlab1 ~]$ cd /home/oracle/dump/[oracle@mlab1 dump]$ ls -lhtotal 4.7G-rw-r----- 1 oracle asmadmin 2.0G Sep 26 12:03 bcm01.dmp-rw-r----- 1 oracle asmadmin 2.0G Sep 26 12:04 bcm02.dmp-rw-r----- 1 oracle asmadmin 521M Sep 26 12:05 bcm03.dmp-rw-r----- 1 oracle asmadmin 121M Sep 26 12:05 bcm04.dmp-rw-r--r-- 1 oracle asmadmin 4.9K Sep 26 12:05 bcm.log
由于以上dump文件已被压缩过，所以后续的bzip2或者gz压缩几乎没有意义，而且耗时超长且压缩比极低：