- 最后登录
- 2013-11-28
- 在线时间
- 13 小时
- 威望
- 32
- 金钱
- 150
- 注册时间
- 2011-12-22
- 阅读权限
- 10
- 帖子
- 19
- 精华
- 0
- 积分
- 32
- UID
- 118
|
1#
发表于 2012-7-12 14:27:39
|
查看: 8562 |
回复: 2
hardware: cpu 4× 4 cores ram 16g
software: win2003 x64 oracle 10.2.0.1 x64
initparameters: 请见附件
做一次expdp测试:
expdp.exe [email=pjh/123@db1]pjh/123@db1[/email] dumpfile=db1.dp directory=dp parallel=40 job_name=jzt1
关闭窗口,然后重新连上该job,先stop一次,重新运行脚本时,提示job仍存在,则我再次连接上job,
尝试再次stop_job:
C:\Documents and Settings\Administrator>expdp pjh/123 attach=jzt1
Export: Release 10.2.0.1.0 - 64bit Production on 星期四, 12 7月, 2012 12:05:11
Copyright (c) 2003, 2005, Oracle. All rights reserved.
连接到: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
作业: JZT1
所有者: PJH
操作: EXPORT
创建者权限: FALSE
GUID: 16C1C2B892FE47978E1740A953B525D2
起始时间: 星期四, 12 7月, 2012 11:55:17
模式: SCHEMA
实例: db1
最大并行度: 40
EXPORT 个作业参数:
参数名 参数值:
CLIENT_COMMAND [email=pjh/********@db1]pjh/********@db1[/email] dumpfile=db1.dmp directory=dp parallel=40
job_name=jzt
状态: STOP PENDING
处理的字节: 1,863,714,920
完成的百分比: 99
当前并行度: 40
作业错误计数: 0
转储文件: H:\db1.DMP
写入的字节: 1,865,031,680
Worker 1 状态:
状态: WORK WAITING
Worker 2 状态:
状态: WORK WAITING
Worker 3 状态:
状态: WORK WAITING
Worker 4 状态:
状态: WORK WAITING
Worker 5 状态:
状态: WORK WAITING
Worker 6 状态:
状态: WORK WAITING
Worker 7 状态:
状态: WORK WAITING
Worker 8 状态:
状态: WORK WAITING
Worker 9 状态:
状态: WORK WAITING
Worker 10 状态:
状态: WORK WAITING
Worker 11 状态:
状态: WORK WAITING
Worker 12 状态:
状态: WORK WAITING
Worker 13 状态:
状态: WORK WAITING
Worker 14 状态:
状态: WORK WAITING
Worker 15 状态:
状态: WORK WAITING
Worker 16 状态:
状态: WORK WAITING
Worker 17 状态:
状态: WORK WAITING
Worker 18 状态:
状态: WORK WAITING
Worker 19 状态:
状态: WORK WAITING
Worker 20 状态:
状态: WORK WAITING
Worker 21 状态:
状态: WORK WAITING
Worker 22 状态:
状态: WORK WAITING
Worker 23 状态:
状态: WORK WAITING
Worker 24 状态:
状态: WORK WAITING
Worker 25 状态:
状态: WORK WAITING
Worker 26 状态:
状态: WORK WAITING
Worker 27 状态:
状态: WORK WAITING
Worker 28 状态:
状态: WORK WAITING
Worker 29 状态:
状态: WORK WAITING
Worker 30 状态:
状态: WORK WAITING
Worker 31 状态:
状态: WORK WAITING
Worker 32 状态:
状态: WORK WAITING
Worker 33 状态:
状态: WORK WAITING
Worker 34 状态:
状态: WORK WAITING
Worker 35 状态:
状态: WORK WAITING
Worker 36 状态:
状态: WORK WAITING
Worker 37 状态:
状态: WORK WAITING
Worker 38 状态:
状态: WORK WAITING
Worker 39 状态:
状态: WORK WAITING
Worker 40 状态:
状态: WORK WAITING
Worker 41 状态:
状态: WORK WAITING
Worker 42 状态:
状态: WORK WAITING
Worker 43 状态:
状态: WORK WAITING
Worker 44 状态:
状态: WORK WAITING
Worker 45 状态:
状态: WORK WAITING
Worker 46 状态:
状态: WORK WAITING
Worker 47 状态:
状态: WORK WAITING
Worker 48 状态:
状态: WORK WAITING
Worker 49 状态:
状态: WORK WAITING
Export> stop_job
是否确实要停止此作业 ([Y]/N):
回车后一直没动静了,过了2个小时的样子,终于回到了windows命令行,但是
select * from dba_tables where table_name ='JZT1' 这一行还在。
另外尝试再次查看job装状态时,却提示:
C:\Documents and Settings\Administrator>expdp pjh/123 attach=jzt1
Export: Release 10.2.0.1.0 - 64bit Production on 星期四, 12 7月, 2012 14:33:45
Copyright (c) 2003, 2005, Oracle. All rights reserved.
连接到: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
ORA-39006: 内部错误
ORA-39065: DISPATCH 中出现意外的主进程异常错误
ORA-44003: SQL 名称无效
ORA-39097: 数据泵作业出现意外的错误 -44003
我知道平行40可能是不合理的,
问题:
1.stop_job长时间挂起可以从哪方面入手分析?
2.能从原理方面给些提示吗?
3.我们应该如何确定一个较合理的并行度?
谢谢
[ 本帖最后由 冰淇凌滋味 于 2012-7-12 14:36 编辑 ] |
|