oracle 执行时长评估,EXPDP:使用ESTIMATE_ONLY参数评估ESTIMATE性能

[oracle@oracle ~]$ expdp \'/ as sysdba\' ESTIMATE_ONLY=y schemas=EYGLE ESTIMATE=statistics

Export: Release 10.2.0.5.0 - 64bit Production on Wednesday, 29 December, 2010 12:29:14

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

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production

With the Partitioning, Real Application Clusters, Data Mining and Real Application Testing options

Starting "SYS"."SYS_EXPORT_SCHEMA_01":  "/******** AS SYSDBA" ESTIMATE_ONLY=y schemas=EYGLE ESTIMATE=statistics

Estimate in progress using STATISTICS method...

Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA

.  estimated "EYGLE"."EYGLEE_ISMG_CURRENT"             3.504 GB

.  estimated "EYGLE"."EYGLEE_ISMG":"M07"               1.702 GB

.  estimated "EYGLE"."EYGLEE_ISMG":"M06"               1.491 GB

.  estimated "EYGLE"."EYGLEE_ISMG":"M03"               1.377 GB

.  estimated "EYGLE"."EYGLEE_ISMG":"M05"               1.306 GB

.  estimated "EYGLE"."EYGLEE_ISMG":"M12"               1.296 GB

.  estimated "EYGLE"."EYGLEE_ISMG":"M08"               1.292 GB

.  estimated "EYGLE"."EYGLEE_ISMG":"M04"               1.290 GB

.  estimated "EYGLE"."EYGLEE_ISMG":"M01"               1.200 GB

.  estimated "EYGLE"."EYGLEE_ISMG":"M02"               1.187 GB

.  estimated "EYGLE"."EYGLEE_ISMG":"M11"               1.147 GB

.  estimated "EYGLE"."EYGLEE_ISMG":"M09"               1.132 GB

.  estimated "EYGLE"."EYGLEE_ISMG":"M10"               1.086 GB

.  estimated "EYGLE"."MONTH_BILLS"                     162.1 MB

.  estimated "EYGLE"."EYGLEE_ISMG2":"M07"              158.9 MB

.  estimated "EYGLE"."SMS_FROM_ISMG":"M09"             138.6 MB

.  estimated "EYGLE"."SMS_FROM_ISMG":"M10"             92.45 MB

.  estimated "EYGLE"."SMS_FROM_ISMG":"M12"             88.28 MB

.  estimated "EYGLE"."SMS_FROM_ISMG":"M01"             87.56 MB

.