admin管理员组文章数量:1660164
[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
.
版权声明:本文标题:oracle 执行时长评估,EXPDP:使用ESTIMATE_ONLY参数评估ESTIMATE性能 内容由热心网友自发贡献,该文观点仅代表作者本人, 转载请联系作者并注明出处:https://www.elefans.com/dongtai/1729849462a1215218.html, 本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容,一经查实,本站将立刻删除。
发表评论