eygle.com   eygle.com
eygle.com eygle
eygle.com  
 

« ORA-39213 Metadata processing not available | Blog首页 | EXPDP:使用ESTIMATE_ONLY参数评估ESTIMATE性能 »

EXPDP测试:性能数据记录
modb.pro

用户在使用EXPDP进行数据导出备份时,遇到了极大的性能问题,备份极其缓慢。

我进行了两个测试,简要记录一下测试结果,测试主机为Linux,2CPU,4G内存,本地硬盘:
10.2.0.2 EXPDP BLOCKS method:5.995 GB,时间:3.5分钟
10.2.0.2 EXPDP BLOCKS method: 22.54 GB ,时间:28分钟
10.2.0.2 EXPDP BLOCKS method: 22.54 GB ,时间:24分钟,并行度为4

以下是测试一,未使用并行:
Export: Release 10.2.0.2.0 - Production on Tuesday, 28 December, 2010 12:03:12

Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
Starting "SYS"."SYS_EXPORT_FULL_01":  '/******** AS SYSDBA' directory=backup dumpfile=EYGLE2.dmp full=y
Estimate in progress using BLOCKS method...
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 5.995 GB
Processing object type DATABASE_EXPORT/TABLEMMACE
Processing object type DATABASE_EXPORT/PROFILE
Processing object type DATABASE_EXPORT/SYS_USER/USER
Processing object type DATABASE_EXPORT/SCHEMA/USER
Processing object type DATABASE_EXPORT/ROLE
Processing object type DATABASE_EXPORT/GRANT/SYSTEM_GRANT/PROC_SYSTEM_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/GRANT/SYSTEM_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/ROLE_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/DEFAULT_ROLE
Processing object type DATABASE_EXPORT/SCHEMA/TABLEMMACE_QUOTA
Processing object type DATABASE_EXPORT/RESOURCE_COST
Processing object type DATABASE_EXPORT/SCHEMA/DB_LINK
Processing object type DATABASE_EXPORT/TRUSTED_DB_LINK
Processing object type DATABASE_EXPORT/SCHEMA/SEQUENCE/SEQUENCE
Processing object type DATABASE_EXPORT/SCHEMA/SEQUENCE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/DIRECTORY/DIRECTORY
Processing object type DATABASE_EXPORT/DIRECTORY/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/CONTEXT
Processing object type DATABASE_EXPORT/SCHEMA/PUBLIC_SYNONYM/SYNONYM
Processing object type DATABASE_EXPORT/SCHEMA/SYNONYM
Processing object type DATABASE_EXPORT/SCHEMA/TYPE/TYPE_MMEC
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIONS/PROCACT_SYSTEM
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PROCOBJ
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/POST_SYSTEM_ACTIONS/PROCACT_SYSTEM
Processing object type DATABASE_EXPORT/SCHEMA/PROCACT_SCHEMA
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/PRE_TABLE_ACTION
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/GRANT/CROSS_SCHEMA/OBJECT_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/INDEX
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/CONSTRAINT
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/COMMENT
Processing object type DATABASE_EXPORT/SCHEMA/PACKAGE/PACKAGE_MMEC
Processing object type DATABASE_EXPORT/SCHEMA/PACKAGE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/FUNCTION/FUNCTION
Processing object type DATABASE_EXPORT/SCHEMA/FUNCTION/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/PROCEDURE
Processing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/FUNCTION/ALTER_FUNCTION
Processing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/ALTER_PROCEDURE
Processing object type DATABASE_EXPORT/SCHEMA/VIEW/VIEW
Processing object type DATABASE_EXPORT/SCHEMA/VIEW/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/VIEW/GRANT/CROSS_SCHEMA/OBJECT_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/VIEW/COMMENT
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type DATABASE_EXPORT/SCHEMA/PACKAGE_BODIES/PACKAGE/PACKAGE_BODY
Processing object type DATABASE_EXPORT/SCHEMA/TYPE/TYPE_BODY
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/FUNCTIONAL_AND_BITMAP/INDEX
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/FUNCTIONAL_AND_BITMAP/INDEX_STATISTICS
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/POST_TABLE_ACTION
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TRIGGER
Processing object type DATABASE_EXPORT/SCHEMA/VIEW/TRIGGER
Processing object type DATABASE_EXPORT/SCHEMA/JOB
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/POST_INSTANCE/PROCACT_INSTANCE
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/POST_INSTANCE/PROCDEPOBJ
Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCOBJ
Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCACT_SCHEMA
. . exported "EYGLEAPP"."MM_HIS"                           4.949 MB   22985 rows
. . exported "EYGLEAPP"."LM_WEB_REQUEST_HIS_BAK"           450.1 MB 2670748 rows
. . exported "EYGLE100"."MM_SENDINFO_HIS"                  203.2 MB 1017328 rows
. . exported "EYGLE200"."MMRECORD_HIS"                     380.9 MB 1787737 rows
. . exported "EYGLEAPP"."ENMM_DEBUG"                        19.15 MB  205150 rows
. . exported "EYGLE200"."MMRECORD_HIS"                     267.6 MB 2521835 rows
. . exported "EYGLEAPP"."LM_LINKID_RESOURCE"               263.2 MB 4121124 rows
. . exported "EYGLEAPP"."LM_WEB_REQUEST_NZ"                2.206 MB   12100 rows
. . exported "EYGLEAPP"."EYGLE_MM_STAT"                      257.4 MB 6036836 rows
. . exported "EYGLEAPP"."MM_HIS"                           1.062 MB   12448 rows
. . exported "EYGLE100"."MM_ORIINFO_HIS"                   181.0 MB 2335277 rows
. . exported "EYGLE100"."EYGLE_LOG"                          1.733 MB   31169 rows
. . exported "EYGLEAPP"."LM_MMRP_SYN_HIS_BAK"              175.9 MB 1640468 rows
. . exported "EYGLE200"."MMREPORT_HIS"                     161.1 MB 2030029 rows
. . exported "EYGLE203"."MMRECORD_HIS"                     42.66 MB  191059 rows
. . exported "EYGLE104"."MM_SENDINFO_HIS"                  106.2 MB  429910 rows
. . exported "EYGLE203"."MMRECORD_HIS"                     20.11 MB  196642 rows
. . exported "EYGLEAPP"."LM_MM_SENDINFO_SYN"               23.63 MB  259638 rows
. . exported "EYGLE203"."MMREPORT_HIS"                     73.29 MB  925822 rows
. . exported "EYGLE104"."MM_ORIINFO_HIS"                   63.80 MB  450218 rows
. . exported "EYGLE200"."MMRECORD"                         5.279 MB   23282 rows
. . exported "EYGLE200"."MMRECORD_MMS"                     21.95 KB     125 rows
. . exported "EYGLEAPP"."BLACK_LIST"                       38.29 MB 1544217 rows
. . exported "EYGLE106"."MM_SENDINFO"                      17.03 KB       2 rows
. . exported "EYGLE200"."MMRECORD"                         1.295 MB   12581 rows
. . exported "EYGLE200"."MMREPORT"                         1.859 MB   23195 rows
. . exported "EYGLEAPP"."LM_MMRP_SYN"                      990.8 KB    8820 rows
. . exported "EYGLEAPP"."PROC_LOG"                         8.191 MB  166463 rows
. . exported "EYGLEAPP"."MS_RIGOR_EN"                      15.11 MB  199049 rows
. . exported "EYGLEAPP"."MM_BAD"                           9.017 MB   66770 rows
. . exported "EYGLEAPP"."LM_USERINFO"                      6.831 MB  201365 rows
. . exported "EYGLE203"."MMRECORD"                         10.52 KB      19 rows
. . exported "EYGLE203"."MMRECORD"                         12.69 KB       3 rows
. . exported "EYGLEAPP"."MS_RIGOR"                         10.32 MB  154035 rows
. . exported "EYGLEAPP"."TEMP_NUMBER"                      11.64 MB   67863 rows
. . exported "EYGLEAPP"."MS_RIGOR_EN_OLD"                  10.32 MB  154035 rows
. . exported "EYGLEAPP"."LM_PANKU_USER"                    7.430 MB  173270 rows
. . exported "EYGLEAPP"."T_TMP_MMBLE_BLK"                  7.341 MB  177509 rows
. . exported "EYGLE102"."MM_SENDINFO_HIS"                  5.098 MB   38895 rows
. . exported "EYGLE200"."SUBSCRIPTION"                     5.465 MB   45889 rows
. . exported "EYGLE203"."MMREPORT"                         7.343 KB       3 rows
. . exported "EYGLEAPP"."LM_WARNMSG"                       3.781 MB   15609 rows
. . exported "EYGLE106"."MM_ORIINFO"                       11.17 KB       2 rows
. . exported "EYGLEAPP"."ENMM_ORDER"                        1.627 MB   32662 rows
. . exported "EYGLEAPP"."LM_WEB_REQUEST_USERINFO"          2.738 MB   35030 rows
. . exported "EYGLEAPP"."ENMM_ORDER_HIS"                    2.454 MB   49950 rows
. . exported "EYGLEAPP"."LM_ORDER_SYN"                     1.911 MB   31853 rows
. . exported "EYGLEAPP"."T_TMP_MMBILE"                     2.036 MB  177509 rows
. . exported "EYGLEAPP"."SYS_EXPORT_SCHEMA_01"             1.110 MB    1871 rows
. . exported "EYGLEAPP"."LM_SSSH_USER_RECORD"              867.2 KB   21067 rows
. . exported "EYGLEAPP"."MM_BAD"                           273.7 KB    3794 rows
. . exported "EYGLEAPP"."USERINFO_TMP"                     1.033 MB   48999 rows
. . exported "SYSMAN"."MGMM_METRICS"                     553.3 KB    2578 rows
. . exported "SYSMAN"."MGMM_STRING_METRIC_HISTORY"       486.1 KB    4260 rows
. . exported "EYGLEAPP"."TEMP_BLACK_LIST"                  432.6 KB   16220 rows
. . exported "EYGLEAPP"."VOOLE_NAME_PASS"                  376.0 KB   12979 rows
. . exported "EYGLEAPP"."LM_LOTTERY_CONTENT"               351.4 KB    5844 rows
. . exported "SYSMAN"."MGMM_HC_OS_COMPONENTS"            215.0 KB     653 rows
. . exported "SYSMAN"."MGMM_HC_VENDOR_SW_COMPONENTS"     215.0 KB     653 rows
. . exported "SYSMAN"."MGMM_JOB_CRED_PARAMS"             11.69 KB      18 rows
. . exported "SYSMAN"."MGMM_JOB_PROP_PARAMS"             8.820 KB      12 rows
. . exported "SYSMAN"."MGMM_JOB_STEP_PARAMS"             127.4 KB    1128 rows
. . exported "SYSMAN"."MGMM_METRICS_1HOUR"               213.4 KB    2643 rows
. . exported "SYSMAN"."MGMM_METRICS_RAW"                 331.7 KB    4144 rows
. . exported "EYGLE102"."MM_SENDINFO"                      18.57 KB      36 rows
. . exported "SYSMAN"."MGMM_JOB_SCHEDULE"                9.437 KB       1 rows
. . exported "SYSMAN"."MGMM_JOB_SEC_INFO"                8.046 KB       4 rows
. . exported "SYSMAN"."MGMM_JOB_USER_PARAMS"             6.210 KB       1 rows
. . exported "SYSMAN"."MGMM_SEC_INFO"                    5.851 KB       1 rows
. . exported "EYGLE101"."MM_SENDINFO_HIS"                  86.58 KB     361 rows
. . exported "EYGLEAPP"."LM_SHIELD_REGION_AREA"            67.82 KB    1237 rows
. . exported "EYGLEAPP"."TEMP_TEST_192"                    86.21 KB    2494 rows
. . exported "EYGLEAPP"."WANGMENG_BLACK_LIST"              6.265 KB      44 rows
. . exported "SYSMAN"."MGMM_ARU_PRODUCT_RELEASE_MAP"     39.28 KB    2621 rows
. . exported "SYSMAN"."MGMM_ECM_SNAPSHOT_MD_COLUMNS"     49.35 KB     508 rows
. . exported "SYSMAN"."MGMM_HC_VENDOR_SW_SUMMARY"        55.97 KB     653 rows
. . exported "SYSMAN"."MGMM_JOB_EXECPLAN"                45.92 KB     366 rows
. . exported "SYSMAN"."MGMM_JOB_PARAM_SOURCE"            28.59 KB     140 rows
. . exported "SYSMAN"."MGMM_JOB_SQL_PARAMS"              6.296 KB       3 rows
. . exported "SYSMAN"."MGMM_JOB_SUBST_PARAMS"            5.664 KB       3 rows
. . exported "SYSMAN"."PARAM_VALUES_TAB"                 9.664 KB      44 rows
. . exported "SYSMAN"."MGMM_METRICS_1DAY"                55.07 KB     620 rows
. . exported "SYSMAN"."MGMM_POLICY_RULE"                 57.67 KB      55 rows
. . exported "SYSMAN"."MGMM_SYSTEM_PERFORMANCE_LOG"         50 KB     746 rows
. . exported "OLAPSYS"."CWM$CLASSIFICATION"              12.40 KB      41 rows
. . exported "OLAPSYS"."CWM$CLASSIFICATIONENTRY"         12.13 KB       5 rows
. . exported "OLAPSYS"."CWM$CLASSIFICATIONTYPE"          11.03 KB      15 rows
. . exported "OLAPSYS"."CWM$DOMAIN"                      13.10 KB      21 rows
. . exported "OLAPSYS"."CWM$FUNCTION"                    11.15 KB      14 rows
. . exported "OLAPSYS"."CWM$MMDEL"                       10.86 KB       2 rows
. . exported "OLAPSYS"."CWM$OBJECTTYPE"                  11.11 KB      15 rows
. . exported "OLAPSYS"."CWM$PARAMETER"                   16.10 KB       5 rows
. . exported "OLAPSYS"."CWM$PROJECT"                     9.484 KB       3 rows
. . exported "OLAPSYS"."CWM2$AWCUBELOADPARM"             5.875 KB       1 rows
. . exported "OLAPSYS"."CWM2$AWCUBELOADTYPE"             5.640 KB       2 rows
. . exported "OLAPSYS"."CWM2$AWDIMLOADPARM"              5.960 KB       4 rows
. . exported "OLAPSYS"."CWM2$AWDIMLOADTYPE"              5.656 KB       2 rows
. . exported "OLAPSYS"."CWM2$MRALL_DESCRIPTORS"          6.710 KB      41 rows
. . exported "SCOTT"."DEPT"                              5.656 KB       4 rows
. . exported "SCOTT"."EMP"                               7.820 KB      14 rows
. . exported "SCOTT"."SALGRADE"                          5.585 KB       5 rows
. . exported "EYGLE101"."MM_ORIINFO_HIS"                   39.15 KB     441 rows
. . exported "EYGLE102"."MM_ORIINFO_HIS"                   24.29 KB     185 rows
. . exported "EYGLE200"."SCANMMSID"                        5.281 KB       1 rows
. . exported "EYGLE200"."SCAN_DB_CONNECTION"               4.929 KB       1 rows
. . exported "EYGLEAPP"."ENMM_CMD_MAP"                      8.617 KB      65 rows
. . exported "EYGLEAPP"."ENMM_CONFIG"                       6.039 KB       4 rows
. . exported "EYGLEAPP"."ENMM_FEE_MAP"                      7.929 KB      42 rows
. . exported "EYGLEAPP"."ENMM_INFO"                         8.320 KB      45 rows
. . exported "EYGLEAPP"."ENMM_JPSX_UNORDER"                 15.97 KB     169 rows
. . exported "EYGLEAPP"."ENMM_LOGIN"                        6.304 KB       3 rows
. . exported "EYGLEAPP"."ENMM_MM_RECORD"                    7.710 KB       5 rows
. . exported "EYGLEAPP"."ENMM_MSMM_CONTENT"                 5.945 KB       1 rows
. . exported "EYGLEAPP"."ENMM_MSMM_CONTROL"                 6.296 KB       1 rows
. . exported "EYGLEAPP"."ENMM_MS_ROUTER"                      8.5 KB       3 rows
. . exported "EYGLEAPP"."ENMM_ROUTER"                       16.39 KB      99 rows
. . exported "EYGLEAPP"."ENMM_TIME_SEED"                    4.921 KB       1 rows
. . exported "EYGLEAPP"."KEY_DETAIL"                       14.39 KB     130 rows
. . exported "EYGLEAPP"."LM_COOP_CONFIG"                   14.71 KB     119 rows
. . exported "EYGLEAPP"."LM_FALANG_REGION_BLACKLIST"       7.093 KB      62 rows
. . exported "EYGLEAPP"."LM_FALANG_WEB_REQUEST"            22.93 KB      69 rows
. . exported "EYGLEAPP"."LM_JPSX_AQGY_USERINFO"            12.55 KB     121 rows
. . exported "EYGLEAPP"."LM_LOTTERY_PRODUCT"               6.890 KB      33 rows
. . exported "EYGLEAPP"."LM_MLQD"                          7.812 KB       1 rows
. . exported "EYGLEAPP"."LM_MMRP_SYN_CHANNELINFO"          10.11 KB      43 rows
. . exported "EYGLEAPP"."LM_PLSSB_YD_VOTE_15"              6.968 KB      11 rows
. . exported "EYGLEAPP"."LM_SERVICE_COUNTER"               6.812 KB      10 rows
. . exported "EYGLEAPP"."LM_SHIELD_CHANNEL"                23.04 KB     160 rows
. . exported "EYGLEAPP"."LM_SSSH_CB"                       26.78 KB     255 rows
. . exported "EYGLEAPP"."LM_TEMP"                          8.007 KB      21 rows
. . exported "EYGLEAPP"."LM_VOTE_TESTMMBILE"                5.25 KB      21 rows
. . exported "EYGLEAPP"."LM_YP_MINING"                     14.71 KB      82 rows
. . exported "EYGLEAPP"."SERVICE_INFO"                     10.53 KB      47 rows
. . exported "EYGLEAPP"."SGW_INFO"                         7.656 KB       9 rows
. . exported "EYGLEAPP"."EYGLE_CRYM_HUMMR"                   5.593 KB       3 rows
. . exported "EYGLEAPP"."EYGLE_PRO_RESTART"                  5.242 KB       1 rows
. . exported "EYGLEAPP"."EYGLE_SYN_RESTART"                  5.242 KB       1 rows
. . exported "EYGLEAPP"."TEMP_587_NOMM"                    12.94 KB     130 rows
. . exported "SYSMAN"."AQ$_MGMM_NOTIFY_QTABLE_S"         7.781 KB       2 rows
. . exported "SYSMAN"."ESM_COLLECTION"                   6.867 KB      32 rows
. . exported "SYSMAN"."MGMM_ADMIN_LICENSES"                  5 KB       5 rows
. . exported "SYSMAN"."MGMM_ARU_FAMILY_PRODUCT_MAP"      12.41 KB     579 rows
. . exported "SYSMAN"."MGMM_ARU_LANGUAGES"               5.921 KB      37 rows
. . exported "SYSMAN"."MGMM_ARU_OUI_COMPONENTS"          18.12 KB     319 rows
. . exported "SYSMAN"."MGMM_ARU_PLATFORMS"               7.968 KB      49 rows
. . exported "SYSMAN"."MGMM_ARU_PRODUCTS"                24.64 KB     524 rows
. . exported "SYSMAN"."MGMM_ARU_RELEASES"                9.796 KB     301 rows
. . exported "SYSMAN"."MGMM_AVAILABILITY"                6.656 KB      11 rows
. . exported "SYSMAN"."MGMM_AVAILABILITY_MARKER"         5.718 KB       5 rows
. . exported "SYSMAN"."MGMM_BLACKOUT_PROXY_TARGETS"      5.046 KB       5 rows
. . exported "SYSMAN"."MGMM_BLACKOUT_REASON"             5.265 KB       1 rows
. . exported "SYSMAN"."MGMM_COLLECTION_PROPERTIES"         6.5 KB       4 rows
. . exported "SYSMAN"."MGMM_CREATED_USERS"               5.695 KB       4 rows
. . exported "SYSMAN"."MGMM_CREDENTIALS2"                7.101 KB       3 rows
. . exported "SYSMAN"."MGMM_CREDENTIAL_SETS"             7.992 KB       8 rows
. . exported "SYSMAN"."MGMM_CREDENTIAL_SET_COLUMNS"      8.390 KB      18 rows
. . exported "SYSMAN"."MGMM_CREDENTIAL_TYPES"            6.789 KB       4 rows
. . exported "SYSMAN"."MGMM_CREDENTIAL_TYPE_COLUMNS"     8.132 KB       8 rows
. . exported "SYSMAN"."MGMM_CREDENTIAL_TYPE_REF"         7.179 KB       1 rows
. . exported "SYSMAN"."MGMM_CURRENT_AVAILABILITY"        6.070 KB       5 rows
. . exported "SYSMAN"."MGMM_CURRENT_METRICS"             25.31 KB     310 rows
. . exported "SYSMAN"."MGMM_CURRENT_SEVERITY"            9.789 KB       1 rows
. . exported "SYSMAN"."MGMM_DB_CONTROLFILES_ECM"         7.593 KB       6 rows
. . exported "SYSMAN"."MGMM_DB_DATAFILES_ECM"             8.25 KB      10 rows
. . exported "SYSMAN"."MGMM_DB_DBNINSTANCEINFO_ECM"      8.062 KB       2 rows
. . exported "SYSMAN"."MGMM_DB_HDM_METRIC_HELPER"        5.601 KB       1 rows
. . exported "SYSMAN"."MGMM_DB_INIT_PARAMS_ECM"          33.35 KB     516 rows
. . exported "SYSMAN"."MGMM_DB_LICENSE_ECM"              6.554 KB       2 rows
. . exported "SYSMAN"."MGMM_DB_RECTSSETTINGS_ECM"        6.375 KB       2 rows
. . exported "SYSMAN"."MGMM_DB_REDOLOGS_ECM"             8.156 KB       6 rows
. . exported "SYSMAN"."MGMM_DB_ROLLBACK_SEGS_ECM"        10.00 KB       2 rows
. . exported "SYSMAN"."MGMM_DB_SGA_ECM"                  6.304 KB      18 rows
. . exported "SYSMAN"."MGMM_DB_TABLEMMACES_ECM"          9.554 KB      10 rows
. . exported "SYSMAN"."MGMM_ECM_ARU_MAP"                 7.304 KB      22 rows
. . exported "SYSMAN"."MGMM_ECM_GEN_SNAPSHOT"            10.83 KB      12 rows
. . exported "SYSMAN"."MGMM_ECM_RESOURCES"               6.523 KB      14 rows
. . exported "SYSMAN"."MGMM_ECM_SNAPSHOT"                8.523 KB       1 rows
. . exported "SYSMAN"."MGMM_ECM_SNAPSHOT_MD_TABLES"      12.43 KB      78 rows
. . exported "SYSMAN"."MGMM_ECM_SNAPSHOT_METADATA"       12.79 KB      36 rows
. . exported "SYSMAN"."MGMM_ECM_SNAP_COMPONENT_INFO"     6.093 KB       4 rows
. . exported "SYSMAN"."MGMM_EMCRYPTO_SEED"               4.960 KB       1 rows
. . exported "SYSMAN"."MGMM_EMD_PING"                    8.796 KB       1 rows
. . exported "SYSMAN"."MGMM_FAILOVER_CALLBACKS"          5.015 KB       2 rows
. . exported "SYSMAN"."MGMM_HA_INFO_ECM"                 6.578 KB       2 rows
. . exported "SYSMAN"."MGMM_HA_MMTR"                     5.578 KB       1 rows
. . exported "SYSMAN"."MGMM_HA_RMAN_CONFIG_ECM"          5.632 KB       2 rows
. . exported "SYSMAN"."MGMM_HC_CPU_DETAILS"              7.078 KB       4 rows
. . exported "SYSMAN"."MGMM_HC_FS_MMUNT_DETAILS"         6.601 KB       9 rows
. . exported "SYSMAN"."MGMM_HC_HARDWARE_MASTER"          8.468 KB       1 rows
. . exported "SYSMAN"."MGMM_HC_IOCARD_DETAILS"           7.109 KB      10 rows
. . exported "SYSMAN"."MGMM_HC_NIC_DETAILS"              7.757 KB       4 rows
. . exported "SYSMAN"."MGMM_HC_OS_PROPERTIES"            33.88 KB     439 rows
. . exported "SYSMAN"."MGMM_HC_OS_SUMMARY"               7.257 KB       1 rows
. . exported "SYSMAN"."MGMM_HC_SYSTEM_SUMMARY"           6.843 KB       1 rows
. . exported "SYSMAN"."MGMM_INV_COMPONENT"               33.90 KB     107 rows
. . exported "SYSMAN"."MGMM_INV_CONTAINER"                   7 KB       2 rows
. . exported "SYSMAN"."MGMM_INV_DEPENDENCY_RULE"         13.65 KB     218 rows
. . exported "SYSMAN"."MGMM_INV_PATCHSET"                7.609 KB       1 rows
. . exported "SYSMAN"."MGMM_INV_VERSIONED_PATCH"         24.94 KB      69 rows
. . exported "SYSMAN"."MGMM_JOB"                         9.632 KB       1 rows
. . exported "SYSMAN"."MGMM_JOB_COMMAND"                 7.648 KB      30 rows
. . exported "SYSMAN"."MGMM_JOB_EVENT"                   5.289 KB       1 rows
. . exported "SYSMAN"."MGMM_JOB_EXECUTION"               12.83 KB       3 rows
. . exported "SYSMAN"."MGMM_JOB_EXEC_SUMMARY"            9.453 KB       1 rows
. . exported "SYSMAN"."MGMM_JOB_HISTORY"                 12.51 KB       3 rows
. . exported "SYSMAN"."MGMM_JOB_NESTED_JOB_TARGETS"      6.320 KB       4 rows
. . exported "SYSMAN"."MGMM_JOB_PURGE_CRITERIA"          5.906 KB       1 rows
. . exported "SYSMAN"."MGMM_JOB_PURGE_POLICIES"          5.304 KB       2 rows
. . exported "SYSMAN"."MGMM_JOB_PURGE_VALUES"            5.664 KB       1 rows
. . exported "SYSMAN"."MGMM_JOB_SINGLE_TARGET_TYPES"     5.429 KB       7 rows
. . exported "SYSMAN"."MGMM_JOB_TYPE_DIMMLAY_INFO"       7.085 KB      31 rows
. . exported "SYSMAN"."MGMM_JOB_TYPE_DIMMLAY_PARAM"      10.73 KB     172 rows
. . exported "SYSMAN"."MGMM_JOB_TYPE_INFO"               9.523 KB      53 rows
. . exported "SYSMAN"."MGMM_JOB_TYPE_URI_INFO"           9.234 KB      61 rows
. . exported "SYSMAN"."MGMM_JOB_VALUE_PARAMS"            6.828 KB      23 rows
. . exported "SYSMAN"."MGMM_LICENSABLE_TARGET_TYPES"     5.570 KB      11 rows
. . exported "SYSMAN"."MGMM_LICENSE_DEFINITIONS"         7.015 KB       5 rows
. . exported "SYSMAN"."MGMM_LOGIN_ASSISTANTS"            5.765 KB       2 rows
. . exported "SYSMAN"."MGMM_MASTER_CHANGED_CALLBACK"     5.617 KB       1 rows
. . exported "SYSMAN"."MGMM_METADATA_SETS"               6.796 KB      19 rows
. . exported "SYSMAN"."MGMM_METRICS_EXT"                 9.179 KB      20 rows
. . exported "SYSMAN"."MGMM_METRIC_COLLECTIONS"          20.58 KB     102 rows
. . exported "SYSMAN"."MGMM_METRIC_COLLECTIONS_REP"      6.078 KB       9 rows
. . exported "SYSMAN"."MGMM_METRIC_DEPENDENCY_DEF"           7 KB      13 rows
. . exported "SYSMAN"."MGMM_METRIC_THRESHOLDS"           25.44 KB     209 rows
. . exported "SYSMAN"."MGMM_NOTIFY_PROFILES"              6.25 KB       3 rows
. . exported "SYSMAN"."MGMM_NOTIFY_QUEUES"               5.531 KB      24 rows
. . exported "SYSMAN"."MGMM_NOTIFY_RULES"                12.72 KB       6 rows
. . exported "SYSMAN"."MGMM_NOTIFY_RULE_CONFIGS"         10.14 KB      30 rows
. . exported "SYSMAN"."MGMM_OMS_PARAMETERS"              6.320 KB       7 rows
. . exported "SYSMAN"."MGMM_PARAMETERS"                  6.406 KB       6 rows
. . exported "SYSMAN"."MGMM_PERFORMANCE_NAMES"           7.960 KB      43 rows
. . exported "SYSMAN"."MGMM_POLICY_GROUP"                8.593 KB       6 rows
. . exported "SYSMAN"."MGMM_POLICY_RULE_CRITERIA"        6.578 KB       7 rows
. . exported "SYSMAN"."MGMM_POLICY_RULE_DEF_COLUMNS"     16.86 KB     111 rows
. . exported "SYSMAN"."MGMM_POLICY_SNAPSHOT_CRITERIA"      6.5 KB      19 rows
. . exported "SYSMAN"."MGMM_POLICY_TARGET_CRITERIA"      6.546 KB       9 rows
. . exported "SYSMAN"."MGMM_POLICY_VIOLATIONS"           6.273 KB       6 rows
. . exported "SYSMAN"."MGMM_POLICY_VIOLATION_ROWS"       8.156 KB      11 rows
. . exported "SYSMAN"."MGMM_POLICY_VIOLATION_VALUES"     7.218 KB      25 rows
. . exported "SYSMAN"."MGMM_PRIVS"                       7.539 KB      19 rows
. . exported "SYSMAN"."MGMM_PRIV_GRANTS"                 7.015 KB      10 rows
. . exported "SYSMAN"."MGMM_PRIV_INCLUDES"               5.609 KB      12 rows
. . exported "SYSMAN"."MGMM_PURGE_POLICY"                9.203 KB      12 rows
. . exported "SYSMAN"."MGMM_PURGE_POLICY_GROUP"          5.867 KB       7 rows
. . exported "SYSMAN"."MGMM_PURGE_POLICY_TARGET_STATE"   8.703 KB      44 rows
. . exported "SYSMAN"."MGMM_REBUILD_INDEXES"             5.585 KB       1 rows
. . exported "SYSMAN"."MGMM_ROLES"                        5.25 KB       1 rows
. . exported "SYSMAN"."MGMM_ROLE_GRANTS"                 5.960 KB       1 rows
. . exported "SYSMAN"."MGMM_SEVERITY"                    34.07 KB     125 rows
. . exported "SYSMAN"."MGMM_TARGETS"                     13.69 KB       5 rows
. . exported "SYSMAN"."MGMM_TARGET_ADD_CALLBACKS"        5.304 KB       1 rows
. . exported "SYSMAN"."MGMM_TARGET_CREDENTIALS"          5.929 KB       1 rows
. . exported "SYSMAN"."MGMM_TARGET_DELETE_CALLBACKS"     5.234 KB       7 rows
. . exported "SYSMAN"."MGMM_TARGET_DELETE_EXCEPTIONS"    5.148 KB       8 rows
. . exported "SYSMAN"."MGMM_TARGET_PROPERTIES"           8.453 KB      45 rows
. . exported "SYSMAN"."MGMM_TARGET_PROP_DEFS"            8.601 KB      14 rows
. . exported "SYSMAN"."MGMM_TARGET_ROLLUP_TIMES"         10.88 KB     110 rows
. . exported "SYSMAN"."MGMM_TARGET_TYPES"                7.507 KB      23 rows
. . exported "SYSMAN"."MGMM_TARGET_TYPE_COMPONENT_MAP"   6.046 KB       4 rows
. . exported "SYSMAN"."MGMM_TYPE_PROPERTIES"             6.523 KB      26 rows
. . exported "SYSMAN"."MGMM_USER_CALLBACKS"              5.382 KB       4 rows
. . exported "SYSMAN"."MGMM_USER_CONTEXT"                5.609 KB       4 rows
. . exported "SYSMAN"."MGMM_USER_FOLDERS"                6.343 KB      18 rows
. . exported "SYSMAN"."MGMM_USER_JOBS"                    5.25 KB       1 rows
. . exported "SYSMAN"."MGMM_USER_TYPE_METRIC_PREFS"      6.171 KB       7 rows
. . exported "SYSMAN"."MGMM_VERSIONS"                    6.242 KB       2 rows
. . exported "SYSMAN"."MGMM_VIEW_USER_CREDENTIALS"       5.328 KB       1 rows
. . exported "SYSTEM"."REPCAT$_AUDIT_ATTRIBUTE"          5.953 KB       2 rows
. . exported "SYSTEM"."REPCAT$_OBJECT_TYPES"             6.507 KB      28 rows
. . exported "SYSTEM"."REPCAT$_RESOLUTION_METHOD"        5.648 KB      19 rows
. . exported "SYSTEM"."REPCAT$_TEMPLATE_STATUS"          5.296 KB       3 rows
. . exported "SYSTEM"."REPCAT$_TEMPLATE_TYPES"           5.914 KB       2 rows
Master table "SYS"."SYS_EXPORT_FULL_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYS.SYS_EXPORT_FULL_01 is:
  /data2/EYGLE/backup/EYGLE2.dmp
Job "SYS"."SYS_EXPORT_FULL_01" successfully completed at 12:06:45

测试二:
Export: Release 10.2.0.2.0 - Production on Tuesday, 28 December, 2010 14:35:17

Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
Starting "EYGLEEN"."SYS_EXPORT_SCHEMA_01":  EYGLEEN/******** directory=backup dumpfile=sms1.dmp parallel=4 schemas=EYGLEEN
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 22.54 GB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/DB_LINK
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
Processing object type SCHEMA_EXPORT/VIEW/VIEW
Processing object type SCHEMA_EXPORT/TABLE/TRIGGER
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type SCHEMA_EXPORT/JOB
. . exported "EYGLEEN"."ME_HIS"                          3.225 GB 15407777 rows
. . exported "EYGLEEN"."MD_HIS"                          1.314 GB 16534402 rows
. . exported "EYGLEEN"."EYGLE_MM_ORACLEIN_HIS_201008"    1004. MB 4292993 rows
. . exported "EYGLEEN"."EYGLE_MM_ORACLEIN_HIS_201009"    786.1 MB 3370471 rows
. . exported "EYGLEEN"."EYGLE_MM_ORACLEIN_HIS_201007"    724.8 MB 3099001 rows
. . exported "EYGLEEN"."EYGLEEN_ORDER_HOUR"              655.6 MB 9025188 rows
. . exported "EYGLEEN"."EYGLE_MM_ORACLEIN_HIS_201010"    653.5 MB 2850395 rows
. . exported "EYGLEEN"."EYGLE_MM_ORACLEIN_HIS_201006"    575.7 MB 2462481 rows
. . exported "EYGLEEN"."EYGLE_MM_ORACLEIN_HIS_201005"    573.9 MB 2451156 rows
. . exported "EYGLEEN"."EYGLE_MM_ORACLEIN_HIS_201004"    536.1 MB 2285741 rows
. . exported "EYGLEEN"."EYGLE_MM_ORACLEIN_HIS_201011"    511.1 MB 2227920 rows
. . exported "EYGLEEN"."EYGLE_MM_ORIINFO_HIS_201008"     475.5 MB 4571123 rows
. . exported "EYGLEEN"."EYGLE_MM_ORACLEIN_HIS_201001"    460.5 MB 1955281 rows
. . exported "EYGLEEN"."EYGLE_MM_MOREPORT_HIS_201008"    431.3 MB 4984605 rows
. . exported "EYGLEEN"."EYGLE_MM_ORIINFO_HIS_201004"     407.2 MB 3870854 rows
. . exported "EYGLEEN"."EYGLE_MM_ORIINFO_HIS_201002"     404.7 MB 3746486 rows
. . exported "EYGLEEN"."EYGLE_MM_ORIINFO_HIS_201009"     397.4 MB 3840547 rows
. . exported "EYGLEEN"."EYGLE_MM_MOMT_HIS"               391.6 MB 1471931 rows
. . exported "EYGLEEN"."EYGLE_MM_MOREPORT_HIS_201009"    341.9 MB 3951024 rows
. . exported "EYGLEEN"."EYGLE_MM_ORACLEIN_HIS_201002"    344.9 MB 1463691 rows
. . exported "EYGLEEN"."SMGLT_MM_MOMT_HIS"               326.1 MB 1563310 rows
. . exported "EYGLEEN"."EYGLE_MM_ORIINFO_HIS_201005"     322.1 MB 3104846 rows
. . exported "EYGLEEN"."EYGLE_MM_ORIINFO_HIS_201010"     312.3 MB 2938475 rows
. . exported "EYGLEEN"."EYGLE_MM_ORIINFO_HIS_201001"     305.7 MB 2670432 rows
. . exported "EYGLEEN"."EYGLE_MM_ORIINFO_HIS_201007"     304.8 MB 2943506 rows
. . exported "EYGLEEN"."EYGLE_MM_ORIINFO_HIS_201006"     301.9 MB 2928212 rows
. . exported "EYGLEEN"."EYGLE_MM_MOREPORT_HIS_201007"    299.7 MB 3463427 rows
. . exported "EYGLEEN"."EYGLE_MM_MOREPORT_HIS_201010"    280.1 MB 3236689 rows
. . exported "EYGLEEN"."EYGLE_MM_ORIINFO_HIS_201011"     264.7 MB 2447075 rows
. . exported "EYGLEEN"."EYGLE_MM_ORACLEIN_HIS_201012"    241.9 MB 1021948 rows
. . exported "EYGLEEN"."EYGLE_MM_MOREPORT_HIS_201005"    232.8 MB 2689503 rows
. . exported "EYGLEEN"."EYGLE_MM_MOREPORT_HIS_201006"    233.7 MB 2701199 rows
. . exported "EYGLEEN"."SMSSTAT_MOMT_HOUR"               217.5 MB 2136969 rows
. . exported "EYGLEEN"."EYGLE_MM_MOREPORT_HIS_201011"    221.5 MB 2559363 rows
. . exported "EYGLEEN"."EYGLE_MM_MOREPORT_HIS_201004"    215.1 MB 2484694 rows
. . exported "EYGLEEN"."EYGLE_MM_MOREPORT_HIS_201001"    203.5 MB 2350487 rows
. . exported "EYGLEEN"."EYGLE_MM_ORACLEIN_HIS_201003"    186.9 MB  793578 rows
. . exported "EYGLEEN"."EYGLE_MM_ORIINFO_HIS_201003"     144.6 MB 1374989 rows
. . exported "EYGLEEN"."EYGLE_MM_MOREPORT_HIS_201002"    138.4 MB 1598489 rows
. . exported "EYGLEEN"."EYGLE_MM_ORIINFO_HIS_201012"     113.2 MB 1053049 rows
. . exported "EYGLEEN"."EYGLE_MM_MOREPORT_HIS_201012"    100.2 MB 1157968 rows
. . exported "EYGLEEN"."EYGLE_MM_MOREPORT_HIS_201003"    74.93 MB  864827 rows
. . exported "EYGLEEN"."SMGLT_MM_ORACLEIN_HIS_201007"    52.29 MB  198402 rows
. . exported "EYGLEEN"."SMSSTAT_MOMT_DAY"                39.26 MB  386623 rows
. . exported "EYGLEEN"."EYGLEEN_ORDER_DAY"               28.12 MB  397104 rows
. . exported "EYGLEEN"."SMGLT_MM_ORIINFO_HIS_201007"     23.20 MB  296351 rows
. . exported "EYGLEEN"."EYGLEEN_MOMTCHANNEL_DAY"         18.58 MB  192715 rows
. . exported "EYGLEEN"."MS_RIGOR_EN"                     15.11 MB  199053 rows
. . exported "EYGLEEN"."SMGLT_MM_ORACLEIN_HIS_201009"    15.28 MB   55044 rows
. . exported "EYGLEEN"."EYGLEEN_MOMTCHANNEL_MONTH"       8.889 MB   91378 rows
. . exported "EYGLEEN"."SMGLT_MM_ORACLEIN_HIS_201008"    13.96 MB   51363 rows
. . exported "EYGLEEN"."SMGLT_MM_ORACLEIN_HIS_201010"    14.45 MB   52219 rows
. . exported "EYGLEEN"."SMGLT_MM_ORACLEIN_HIS_201012"    9.945 MB   36728 rows
. . exported "EYGLEEN"."EYGLEEN_ORDERCHANNEL_DAY"        9.850 MB  107503 rows
. . exported "EYGLEEN"."EYGLEEN_FEILONG_AREA"            9.155 MB  150846 rows
. . exported "EYGLEEN"."APP_TOUSU"                       8.157 MB   21987 rows
. . exported "EYGLEEN"."SMGLT_MM_ORACLEIN_HIS_201003"    7.898 MB   29049 rows
. . exported "EYGLEEN"."SMSSTAT_MOMT_TEST"               11.64 KB       6 rows
. . exported "EYGLEEN"."SMGLT_MM_ORACLEIN_HIS_201001"    6.099 MB   24153 rows
. . exported "EYGLEEN"."SMGLT_MM_ORACLEIN_HIS_201005"    6.187 MB   22921 rows
. . exported "EYGLEEN"."SMGLT_MM_ORACLEIN_HIS_201011"    6.457 MB   23984 rows
. . exported "EYGLEEN"."SMGLT_MM_ORIINFO_HIS_201008"     5.581 MB   77689 rows
. . exported "EYGLEEN"."SMGLT_MM_ORACLEIN_HIS_201004"    4.811 MB   18158 rows
. . exported "EYGLEEN"."SMGLT_MM_ORIINFO_HIS_201009"     3.821 MB   54789 rows
. . exported "EYGLEEN"."SMGLT_MM_ORIINFO_HIS_201010"     3.576 MB   50994 rows
. . exported "EYGLEEN"."SMGLT_MM_ORIINFO_HIS_201005"     2.643 MB   37951 rows
. . exported "EYGLEEN"."SMGLT_MM_ORACLEIN_HIS_201002"    2.865 MB   10701 rows
. . exported "EYGLEEN"."EYGLEEN_FEILONG_DAY"             2.880 MB   34645 rows
. . exported "EYGLEEN"."SMGLT_MM_ORIINFO_HIS_201003"     1.849 MB   26258 rows
. . exported "EYGLEEN"."SMGLT_MM_ORIINFO_HIS_201012"     2.441 MB   35606 rows
. . exported "EYGLEEN"."SMGLT_MM_ORIINFO_HIS_201001"     1.299 MB   20086 rows
. . exported "EYGLEEN"."SMGLT_MM_ORIINFO_HIS_201004"     1.181 MB   16705 rows
. . exported "EYGLEEN"."SMGLT_MM_ORIINFO_HIS_201011"     1.560 MB   22631 rows
. . exported "EYGLEEN"."EYGLEEN_ORDER_MONTH"             1.088 MB   15498 rows
. . exported "EYGLEEN"."T_BMS_LOG_ACT"                   1.128 MB   27902 rows
. . exported "EYGLEEN"."T_BMS_LOG_IN"                    928.6 KB   24637 rows
. . exported "EYGLEEN"."SMGLT_MM_ORIINFO_HIS_201002"     679.3 KB    9309 rows
. . exported "EYGLEEN"."EYGLEEN_ORDERCHANNEL_MONTH"      452.8 KB    4713 rows
. . exported "EYGLEEN"."ERROR_CODE"                      184.2 KB    3064 rows
. . exported "EYGLEEN"."SMGLT_FINANCE_ORDER_MONTH"       87.89 KB    1533 rows
. . exported "EYGLEEN"."APP_INFO"                        8.062 KB      38 rows
. . exported "EYGLEEN"."APP_TIMESEND_CONTENT"            6.812 KB      11 rows
. . exported "EYGLEEN"."APP_TIMESEND_TASK"               7.781 KB       1 rows
. . exported "EYGLEEN"."APP_TOUSU_CHANNEL"               22.36 KB      87 rows
. . exported "EYGLEEN"."BMS_ADMIN"                       16.29 KB      63 rows
. . exported "EYGLEEN"."BMS_BASIC_ITEM"                  21.68 KB     144 rows
. . exported "EYGLEEN"."BMS_COMPANY"                     6.976 KB       8 rows
. . exported "EYGLEEN"."BMS_GROUP"                       6.921 KB      14 rows
. . exported "EYGLEEN"."BMS_MENU"                        22.32 KB     835 rows
. . exported "EYGLEEN"."SERVICE_INFO"                    10.36 KB      44 rows
. . exported "EYGLEEN"."SERVICE_INFO_MMS_WAP"            6.421 KB      25 rows
. . exported "EYGLEEN"."SGW_INFO"                        7.656 KB       9 rows
. . exported "EYGLEEN"."EYGLEEN_CHANNEL_INFO"            11.96 KB      28 rows
. . exported "EYGLEEN"."YPYD_AREA_CODE"                  5.648 KB      32 rows
. . exported "EYGLEEN"."YPYD_ZXF_TEMP"                   22.44 KB     839 rows
Master table "EYGLEEN"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for EYGLEEN.SYS_EXPORT_SCHEMA_01 is:
  /data3/backup/sms1.dmp
Job "EYGLEEN"."SYS_EXPORT_SCHEMA_01" successfully completed at 14:59:19

测试数据留存!供参考!


历史上的今天...
    >> 2015-12-29文章:
    >> 2012-12-29文章:
    >> 2008-12-29文章:
    >> 2007-12-29文章:
    >> 2006-12-29文章:
    >> 2005-12-29文章:
           遭遇Referer Spam Too
           spam留言知几何?
    >> 2004-12-29文章:
           并购狂潮-EMC的动作

By eygle on 2010-12-29 09:43 | Comments (4) | FAQ | 2687 |

4 Comments

如果11g,加上compression=all会更快

如果11g,加上compression=all会更快

曾经用ibm 750导入压缩前有120G数据的表,6分钟


CopyRight © 2004~2020 云和恩墨,成就未来!, All rights reserved.
数据恢复·紧急救援·性能优化 云和恩墨 24x7 热线电话:400-600-8755 业务咨询:010-59007017-7040 or 7037 业务合作: marketing@enmotech.com