本文对比了Oracle数据泵Exp和Expdp在导出大规模数据时的速度，1.3亿记录的Exp导出耗时约50分钟，1.8亿记录的直接路径Exp耗时22分钟，1.6亿记录的Expdp导出用时32分钟。尽管Expdp在导入时表现更好，但会生成临时表并可能遇到Bug。
Exp 导出与 Expdp 的速度与时间对比
nohup time exp sms/sms file=smsmg_p2.dmp tables=SMSMG:M02 &
nohup time exp sms/sms file=smsmg_p3.dmp tables=SMSMG:M03 direct=y recordlength=65535 &
nohup time expdp sms/sms dumpfile=smsmg_p4.dmp directory=dataorg tables=SMSMG:M04 PARALLEL=2 &
首先，使用常规路径导出，1.3亿记录，大约耗时50分钟：
Export: Release 10.2.0.2.0 - Production on Thu Sep 17 23:22:57 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set
About to export specified tables via Conventional Path ...
. . exporting table SMSMG
. . exporting partition M02 134528204 rows exported
Export terminated successfully with warnings.
1578.95user 260.72s
最低0.47元/天 解锁文章
1053
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
