首页
技术基础
备份恢复
SQL优化
诊断案例
BLOG
留言板
服务
生活
网摘
阅读
下载
墨天轮
English
eygle.com - 留言簿 - 回复留言 - Powered by eYgLe.Com
返回留言簿
回 复 留 言
留言ID:
留言原文:
To
:
盖老师
我想问一下关于oracle enq js - wdw op 等待事件产生的原因?
From
:
sunyunyi
2010.03.14 23:17
管理密码:
请输入管理密码, 否则无法回复.
斑竹昵称:
信息图标: ( 随机 )
BB 代码:
字体
宋体
黑体
隶书
楷体
幼圆
Arial
颜色
天蓝
品蓝
蓝色
深蓝
橙色
橙红
深红
红色
砖红
暗红
绿色
灰绿
海绿
粉红
果红
桃红
紫色
紫蓝
棕木
沙褐
土黄
深褐
土绿
灰色
大小
1号
2号
3号
4号
5号
内容:
如果想删除回复, 请点击最下面的删除回复按钮.
从这里可以找到JS的含义 http://www.eygle.com/archives/2009/11/v_dollar_enqueue_statis.html oracle enq js - wdw op如果是长时间的等待,可能是JOB的运行出了问题,可以尝试重启或kill CJQ0进程,如果频繁出现,需要考虑确认是否是Bug。 Metalink 564957.1 记录了这样一种情况: Symptoms Everything is scheduled via DBMS_SCHEDULER. The problem is that all jobs are locked and cannot run. It is a 2 node RAC. The jobs are hanging on both nodes becasue nothing is working for the DBMS_SCHEDULER at the window-times. Cause select * from gv$lock where block <> 2; INST_ID ADDR KADDR SID TYPE ID1 ID2 LMODE REQUEST CTIME BLOCK 1 000000011F7E6200 000000011F7E6220 322 JS 0 8 0 6 3 0 2 000000011F7E0D70 000000011F7E0D90 321 JS 0 8 0 6 0 0 2 000000011F7E0B10 000000011F7E0B30 321 JS 0 8 6 0 582858 1 select * from gv$session_wait_history where inst_id = 2 and sid = 321; INST_ID SID SEQ# EVENT# EVENT P1TEXT P1 P2TEXT P2 P3TEXT P3 WAIT_TIME WAIT_COUNT 2 321 1 875 enq: JS - wdw op name|mode 1246953478 service ID 0 queue type 8 49 1 2 321 2 875 enq: JS - wdw op name|mode 1246953478 service ID 0 queue type 8 49 1 2 321 3 875 enq: JS - wdw op name|mode 1246953478 service ID 0 queue type 8 49 1 2 321 4 875 enq: JS - wdw op name|mode 1246953478 service ID 0 queue type 8 49 1 2 321 5 875 enq: JS - wdw op name|mode 1246953478 service ID 0 queue type 8 49 1 2 321 6 875 enq: JS - wdw op name|mode 1246953478 service ID 0 queue type 8 49 1 2 321 7 875 enq: JS - wdw op name|mode 1246953478 service ID 0 queue type 8 49 1 2 321 8 216 library cache lock handle address 4805070384 lock address 4063778832 100*mode+namespace 351 0 1 2 321 9 3 rdbms ipc message timeout 200 0 0 195 1 2 321 10 875 enq: JS - wdw op name|mode 1246953478 service ID 0 queue type 8 39 1 Found 'ENQ: JS - WDW OP' enqueue. Solution From sysstem state dump, PROCESS 15 CJQ0 is waiting for 'enq: JS - wdw op' for X mode, but it is also holding it in X mode: => Self deadlock PROCESS 15: ---------------------------------------- SO: 0x11f47e310, type: 2, owner: (nil), flag: INIT/-/-/0x00 (process) Oracle pid=15, calls cur/top: 0x11f6f25d0/0x11f6f25d0, flag: (2) SYSTEM oracle@fons.uza.uia.ac.be (CJQ0) ... ... SO: 0x11f6b3498, type: 4, owner: 0x11f47e310, flag: INIT/-/-/0x00 (session) sid: 321 trans: 0x118c33398, creator: 0x11f47e310, flag: (100051) USR/- BSY/-/-/-/-/- DID: 0002-000F-00000003, short-term DID: 0002-000F-00000004 txn branch: (nil) oct: 0, prv: 0, sql: (nil), psql: (nil), user: 0/SYS waiting for 'enq: JS - wdw op' blocking sess=0x(nil) seq=22514 wait_time=0 seconds since wait started=3 name|mode=4a530006, service ID=0, queue type=8 Dumping Session Wait History for 'enq: JS - wdw op' count=1 wait_time=489326 name|mode=4a530006, service ID=0, queue type=8 .... SO: 0x11f7e0d70, type: 5, owner: 0x11f6b3498, flag: INIT/-/-/0x00 (enqueue) JS-00000000-00000008 DID: 0002-000F-00000003 lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 res_flag: 0x3 res: 0x0x11f8a44d0, req: X, lock_flag: 0x8 own: 0x0x11f6b3498, sess: 0x0x11f6b3498, proc: 0x0x11f47e310, prv: 0x0x11f8a44f0 slk: 0x0x11d1b6028 .... SO: 0x11f7e0b10, type: 5, owner: 0x11f6b3498, flag: INIT/-/-/0x00 (enqueue) JS-00000000-00000008 DID: 0002-000F-00000003 lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 res_flag: 0x3 res: 0x0x11f8a44d0, mode: X, lock_flag: 0x0 own: 0x0x11f6b3498, sess: 0x0x11f6b3498, proc: 0x0x11f47e310, prv: 0x0x11f8a44e0 slk: 0x0x11d1b5ed8 Solution ======= To kill the CJQ0 process from OS. 供参考!
删 除 回 复
管理密码:
请输入管理员密码, 只有版主才能删除回复.
Copyright © 2003~2012
eygle.com
All Rights Reserved.
Powered by:
www.eygle.com