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

.

本文标签： 时长性能参数ORACLEEXPDP

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