2）Oracle官方文檔中關于ESTIMATE參數的描述
參考鏈接：http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/dp_export.htm#sthref105
引用內容如下：
ESTIMATE

Default: BLOCKS

Purpose

Specifies the method that
Export will use to estimate how
much disk space each table in the export job will consume (in bytes).
The estimate is printed in the log file and displayed on the client\\\’s
standard output device. The estimate is for table row data only; it does
not include metadata.

Syntax and Description

ESTIMATE={BLOCKS | STATISTICS}

BLOCKS – The estimate is calculated by multiplying the
number of database blocks used by the source objects, times the
appropriate block sizes.

STATISTICS – The estimate is calculated using statistics
for each table. For this method to be as accurate as possible, all
tables should have been analyzed recently.

Restrictions

If the Data Pump export job involves compressed tables, the default
size estimation given for the compressed table is inaccurate when ESTIMATE=BLOCKS
is used. This is because the size estimate does not reflect that the
data was stored in a compressed form. To get a more accurate size
estimate for compressed tables, use ESTIMATE=STATISTICS.

Example

The following example shows a use of the ESTIMATE
parameter in which the estimate is calculated using statistics for the employees
table:

> expdp hr/hr TABLES=employees ESTIMATE=STATISTICS DIRECTORY=dpump_dir1
 DUMPFILE=estimate_stat.dmp

2.顯式指定ESTIMATE參數為BLOCKS
ora10g@secDB /expdp$ expdp sec/sec directory=expdp_dir dumpfile=sec.dmp ESTIMATE=BLOCKS

Export: Release 10.2.0.3.0 – 64bit Production on Saturday, 10 April, 2010 6:23:26

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

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 – 64bit Production
With the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engine options
Starting SEC.SYS_EXPORT_SCHEMA_01:  sec/******** directory=expdp_dir dumpfile=sec.dmp ESTIMATE=BLOCKS
Estimate in progress using BLOCKS method…
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
.  estimated SEC.TEST_SEC                                2 MB
.  estimated SEC.TEST_SEC1                               2 MB
.  estimated SEC.TEST_SEC2                               2 MB
Total estimation using BLOCKS method: 6 MB
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/TABLE/TABLE
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
. . exported SEC.TEST_SEC                            1.018 MB   11716 rows
. . exported SEC.TEST_SEC1                           1.018 MB   11717 rows
. . exported SEC.TEST_SEC2                           1.018 MB   11718 rows
Master table SEC.SYS_EXPORT_SCHEMA_01 successfully loaded/unloaded
******************************************************************************
Dump file set for SEC.SYS_EXPORT_SCHEMA_01 is:
  /expdp/sec.dmp
Job SEC.SYS_EXPORT_SCHEMA_01 successfully completed at 06:23:37

此時預估單位是按照數據庫塊進行統計的，相比最終導出的大小來說不是很準確，不過有一定的參考意義。

3.指定ESTIMATE參數為STATISTICS
ora10g@secDB /expdp$ expdp sec/sec directory=expdp_dir dumpfile=sec.dmp ESTIMATE=STATISTICS

Export: Release 10.2.0.3.0 – 64bit Production on Saturday, 10 April, 2010 6:22:02

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

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 – 64bit Production
With the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engine options
Starting SEC.SYS_EXPORT_SCHEMA_01:  sec/******** directory=expdp_dir dumpfile=sec.dmp ESTIMATE=STATISTICS
Estimate in progress using STATISTICS method…
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
.  estimated SEC.TEST_SEC                            9.558 KB
.  estimated SEC.TEST_SEC1                           9.558 KB
.  estimated SEC.TEST_SEC2                           9.558 KB
Total estimation using STATISTICS method: 28.67 KB
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/TABLE/TABLE
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
. . exported SEC.TEST_SEC                            1.018 MB   11716 rows
. . exported SEC.TEST_SEC1                           1.018 MB   11717 rows
. . exported SEC.TEST_SEC2                           1.018 MB   11718 rows
Master table SEC.SYS_EXPORT_SCHEMA_01 successfully loaded/unloaded
******************************************************************************
Dump file set for SEC.SYS_EXPORT_SCHEMA_01 is:
  /expdp/sec.dmp
Job SEC.SYS_EXPORT_SCHEMA_01 successfully completed at 06:22:14

此時的統計結果比較離譜，是何原因？
真實的原因是在使用ESTIMATE=STATISTICS參數預估時，數據來源是表的分析數據，如果表未曾分析過或分析數據不準確就會導致此處的數據失真。

4.在數據庫中對sec用戶做一下分析，然后再完成一次數據導出
1）對sec用戶進行分析
sys@ora10g> exec dbms_stats.gather_schema_stats(OWNNAME=>\\\’SEC\\\’,ESTIMATE_PERCENT=>10,DEGREE=>4,cascade=>true);

PL/SQL procedure successfully completed.

2）再次導出sec用戶下的數據
ora10g@secDB /expdp$ expdp sec/sec directory=expdp_dir dumpfile=sec.dmp ESTIMATE=STATISTICS

Export: Release 10.2.0.3.0 – 64bit Production on Saturday, 10 April, 2010 6:30:20

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

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 – 64bit Production
With the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engine options
Starting SEC.SYS_EXPORT_SCHEMA_01:  sec/******** directory=expdp_dir dumpfile=sec.dmp ESTIMATE=STATISTICS
Estimate in progress using STATISTICS method…
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
.  estimated SEC.TEST_SEC2                           993.6 KB
.  estimated SEC.TEST_SEC1                           993.6 KB
.  estimated SEC.TEST_SEC                            993.5 KB
Total estimation using STATISTICS method: 2.910 MB
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/TABLE/TABLE
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/TABLE/STATISTICS/TABLE_STATISTICS
. . exported SEC.TEST_SEC2                           1.018 MB   11718 rows
. . exported SEC.TEST_SEC1                           1.018 MB   11717 rows
. . exported SEC.TEST_SEC                            1.018 MB   11716 rows
Master table SEC.SYS_EXPORT_SCHEMA_01 successfully loaded/unloaded
******************************************************************************
Dump file set for SEC.SYS_EXPORT_SCHEMA_01 is:
  /expdp/sec.dmp
Job SEC.SYS_EXPORT_SCHEMA_01 successfully completed at 06:30:35

OK，此時的預估數據與最后的生成數據大小較為接近。

5.不指定ESTIMATE參數
ora10g@secDB /expdp$ expdp sec/sec directory=expdp_dir dumpfile=sec.dmp

Export: Release 10.2.0.3.0 – 64bit Production on Saturday, 10 April, 2010 7:26:54

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

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 – 64bit Production
With the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engine options
Starting SEC.SYS_EXPORT_SCHEMA_01:  sec/******** directory=expdp_dir dumpfile=sec.dmp
Estimate in progress using BLOCKS method…
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 6 MB
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/TABLE/TABLE
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/TABLE/STATISTICS/TABLE_STATISTICS
. . exported SEC.TEST_SEC                            1.018 MB   11716 rows
. . exported SEC.TEST_SEC1                           1.018 MB   11717 rows
. . exported SEC.TEST_SEC2                           1.018 MB   11718 rows
Master table SEC.SYS_EXPORT_SCHEMA_01 successfully loaded/unloaded
******************************************************************************
Dump file set for SEC.SYS_EXPORT_SCHEMA_01 is:
  /expdp/sec.dmp
Job SEC.SYS_EXPORT_SCHEMA_01 successfully completed at 07:27:05

在不指定ESTIMATE參數時，默認會使用BLOCKS進行估算，不過，具體的數據庫對象進估算被省略，僅有以下信息提示：
Total estimation using BLOCKS method: 6 MB

6.小結
雖然ESTIMATE參數提供給我們一種預估大小的功能，不過在使用EXPDP進行數據備份時，還是盡量不要使用，畢竟所有額外的操作都是有代價的。

Good luck.

secooler
10.04.10

— The End —

更多關于云服務器，域名注冊，虛擬主機的問題，請訪問三五互聯官網：m.shinetop.cn





猜你還會喜歡下面的內容

• 三五互聯虛擬主機全新升級上線
• 2025雙11云服務器搶購攻略：爆款配置三年特價，一步省三年，速搶！
• 三五互聯雙11：1G虛擬主機驚爆價只要18元
• 虛擬主機升級：提升流量配額與功能更新
• 企業郵箱的續費流程
• 如何購買域名的虛擬主機
• 如何將網頁綁定在域名上
• 如何將購買的域名綁定到 Web
• 如何把空間和域名綁定
• 虛擬主機共享ip怎么更換獨立ip
• 做網站用虛擬主機怎么樣
• 做網站什么時候要用到虛擬主機
• 去哪里買的空間和域名比較優質
• 買下域名后每年都要交錢嗎
• 怎么購買低價的虛擬主機
• 一年十幾塊錢的虛擬主機怎么樣

熱門標簽

其他問題云服務器問題域名及賬戶問題企業郵局市場咨詢云服務器云建站/云站群/小程序虛擬主機企業郵箱網絡知識域名注冊域名備案域名商標注冊云主機更多標簽...