www.eygle.com

« AIX Oracle 安装纪要 - cpio 、X11 forwarding | Blog首页 | Oracle impdp的ignore及 fromuser / touser 功能 »

工作日志：2亿记录的exp导出时间记录

一个短信表的分区，使用direct模式导出：
exp sms/sms file=smsmg_p7.dmp tables=SMSMG:M07 direct=y recordlength=65535 statistics=none

导出时间大约28分钟：

Export: Release 10.2.0.2.0 - Production on Fri Sep 25 22:59:33 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 Direct Path ...
. . exporting table                    SMSMG
. . exporting partition                            M07  256466785 rows exported
Export terminated successfully without warnings.
42.33user 666.59system 28:02.65elapsed 42%CPU (0avgtext+0avgdata 0maxresident)k
0inputs+0outputs (27major+3131minor)pagefaults 0swaps

导出文件大小为59G左右：
-rw-r--r--  1 oracle oinstall 63306875535 Sep 25 23:27 smsmg_p7.dmp

主机为4颗4核 处理器：

[root@sms proc]# cat cpuinfo |grep CPU
model name      : Intel(R) Xeon(R) CPU           E7330  @ 2.40GHz
model name      : Intel(R) Xeon(R) CPU           E7330  @ 2.40GHz
model name      : Intel(R) Xeon(R) CPU           E7330  @ 2.40GHz
model name      : Intel(R) Xeon(R) CPU           E7330  @ 2.40GHz
model name      : Intel(R) Xeon(R) CPU           E7330  @ 2.40GHz
model name      : Intel(R) Xeon(R) CPU           E7330  @ 2.40GHz
model name      : Intel(R) Xeon(R) CPU           E7330  @ 2.40GHz
model name      : Intel(R) Xeon(R) CPU           E7330  @ 2.40GHz
model name      : Intel(R) Xeon(R) CPU           E7330  @ 2.40GHz
model name      : Intel(R) Xeon(R) CPU           E7330  @ 2.40GHz
model name      : Intel(R) Xeon(R) CPU           E7330  @ 2.40GHz
model name      : Intel(R) Xeon(R) CPU           E7330  @ 2.40GHz
model name      : Intel(R) Xeon(R) CPU           E7330  @ 2.40GHz
model name      : Intel(R) Xeon(R) CPU           E7330  @ 2.40GHz
model name      : Intel(R) Xeon(R) CPU           E7330  @ 2.40GHz
model name      : Intel(R) Xeon(R) CPU           E7330  @ 2.40GHz

exp的性能还是可以接受的。

-The End-

By eygle on 2009-09-26 14:36 | Comments (6) | Posted to Case | Edit |Pageviews:

相关文章	随机文章
Exp 导出与 Expdp 的速度与时间对比 换一种思路 - 通过导出导入进行数据整理 Export ORA-00904: "Ifreepool": Invalid Identifier Oracle EXP/IMP与临时对象的管理方式 Oracle跨版本导出EXP-00003错误的解决	进京两周年记-Eygle在北京的生活之二 10gRAC系列之三-使用crs_stat工具查看资源状态 如何备份OutLook Express的邮件规则 两只蝴蝶 《深入浅出Oracle》代码及服务

留言 (6)

Posted by: sync at September 27, 2009 6:02 PM

Posted by: eygle at September 28, 2009 8:54 AM

Posted by: 明月 at September 28, 2009 9:54 AM

Posted by: l1t at September 29, 2009 9:12 AM

Posted by: eygle at September 29, 2009 3:01 PM

Posted by: William Kwok at January 27, 2010 2:35 PM

发表留言:

Name(*):
Email(*):

You Link: Remember Me? YesNo
验证码(*): (输入验证码后方可评论,谢谢支持)
Comments: