eygle.com   eygle.com
eygle.com  
 
留言簿 - Oracle Life - Powered by Eygle.com
eygle.com 我要留言
《深入解析Oracle》- DBA 2.0时代技术交流会
昵称
内容 页: 1 - << < 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 > >> - 403
# 44563
wolfsun




To: 盖老师
  盖老师您好:
我想请教您关于OPAQUE_TRANSFORM 提示的相关信息。
From: wolfsun
2010.03.18 00:52

版主选项: 回复 编辑
# 44562
zhouhuabin


来自: 千方


To:
  请教盖老师一个问题:10g的标准版里,建分区表的时候提示ORA-00439: feature not enabled: Database resource manager
是参数设置的问题还是oracle的bug,不想重装oracle,如何办?

From: zhouhuabin
2010.03.16 19:41
To: zhouhuabin
  标准版不支持分区功能,企业版才有的!
From: eygle
2010.03.17 02:36

版主选项: 回复 编辑
# 44561
sunyunyi




To: 盖老师
  谢谢盖老师 通过KILL CJQ0
 enq js - wdw op等该不在出现在首要等该事件中;

From: sunyunyi
2010.03.15 17:49
To: sunyunyi
  绝不应该,你发AWR报告到我邮箱看看吧
From: eygle
2010.03.15 21:12

版主选项: 回复 编辑
# 44560
ScorpJ




To:
  盖老师,
  ACOUG首次活动报名一周了, 名单还没看到诶!啥样的人可以去啊?
From: ScorpJ
2010.03.15 01:50

版主选项: 回复 编辑
# 44559
sunyunyi




To: 盖老师
  我想问一下关于oracle enq js - wdw op 等待事件产生的原因?
From: sunyunyi
2010.03.14 23:17
To: sunyunyi
  从这里可以找到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.

供参考!

From: eygle
2010.03.15 01:07

版主选项: 回复 编辑
# 44558
suzhiping


来自: 北京


To: 盖老师
  盖老师:
  您好!我刚刚作了一个Linux Redhat 4U8环境下的oracle10gR2的RAC 数据库,现在遇见以下两个问题:
1、进行断电重启测试,发现两个节点的crs不能自动起来,一般只能自动启动vip,gsd,ons都处于UNKNOWN状态;
2、重启两个节点数据库,备节点的数据库开始open到open结束需要很长的时间(至少15分钟),我看了alert 日志,开始ALTER DATABASE OPEN后一直等待在:Picked broadcast on commit scheme to generate SCNs过程中,如果我关闭主节点的实例,则备点的库能较快的open。
我是数据库的初学者,公司专职DBA刚刚离职,盖老师可以帮我提供一些合适的建议么?
From: suzhiping
2010.03.12 02:36
To: suzhiping
  那可能是你的心跳配置的有问题,两个节点不能及时同步SCN。
From: eygle
2010.03.13 08:48

版主选项: 回复 编辑
# 44557
sunyunyi




To:
  盖老师您好:

我想问一下关于oracle enq js - wdw op 等待事件产生的原因,是不是备份引起的,
我们用的是tsm备份到磁带。
From: sunyunyi
2010.03.08 17:37

版主选项: 回复 编辑
# 44556
Taoyoyo




To: 盖老师
  盖老师好,我新作了一个oracle10g的数据库,不知为什么,sql初始化时间特别长,不知应该调整哪些参数。
这里有详细的说明:http://bbs.chinaunix.net/thread-1674113-1-1.html

请盖老师指点一下,怎么改正一下呢!

可以邮件给我!

非常感谢!
From: Taoyoyo
2010.03.08 01:04

版主选项: 回复 编辑
# 44555
笨小笨




To: 盖老师
  老师你好:
 我想问一下如何得知一个正在执行的存储过程运行到了代码的哪一步了
比如 您书中的例子 我改一下
 create or replace procedure calling
  is
  begin
  dbms_lock.sleep(100);
  dbms_lock.sleep(300);
  dbms_lock.sleep(200);
  end;
从v$session中知道了会话正在 exec calling
但如何知道是哪个SLEEP 在等待
From: 笨小笨
2010.03.04 20:30

版主选项: 回复 编辑
# 44554
Haiyuan


来自: Dongguan


To: 蓋老師
  
From: Haiyuan
2010.03.02 20:40

版主选项: 回复 编辑

页: 1 - << < 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 > >> - 403
我要留言
Copyright © 2003~2012 eygle.com All Rights Reserved.
Powered by: www.eygle.com