52 积分	0 好友	6 主题

发消息

[常规总体性能调优] ora-07445 kksxsccmp+0428报错

1^#

发表于 2013-4-19 09:09:24 | 查看: 4226| 回复: 3

OS：AIX 6100-06-09-1228
rdbms: 10.2.0.5.9
alert日志中一直出现以下报错，在mos上查不到相关的文档，请帮忙给分析一下，谢谢！

Thu Apr 18 14:43:24 GMT+08:00 2013Errors in file /oracle/admin/pmdb/udump/pmdb1_ora_1835980.trc:
ORA-07445: : [kksxsccmp+0428] [SIGSEGV] [Address not mapped to object] [0xE86300987C7B03DA] [] []
Thu Apr 18 14:43:25 GMT+08:00 2013Trace dumping is performing id=[cdmp_20130418144325]
Thu Apr 18 14:43:49 GMT+08:00 2013Thread 1 advanced to log sequence 33572 (LGWR switch)

复制代码

pmdb1_ora_1835980.rar

464.13 KB, 下载次数: 748

分享0

收藏0 回复只看该作者道具举报

xinxin415415

4^#

发表于 2013-4-24 10:06:34

刘大，您好
我同时也在MOS上发了一个SR，support说这个是一个新的bug，oracle已经不出补丁了，建议你升级11.2.0.3

回复只看该作者道具举报

Maclean Liu(刘相兵

3^#

发表于 2013-4-19 09:23:36

Cursor#10(1104a1c58) state=BOUND curiob=1108eefd0
curflg=46 fl2=0 par=0 ses=700001393d32770
sqltxt(7000002d4649eb0)=select seq_d_status_chg.nextval from dual
  hash=5fda2da420537ff1d4b308069c378f53
  parent=7000012c36623b0 maxchild=01 plk=7000011895fe2d8 ppn=n
cursor instantiation=1108eefd0 used=1366267404
child#0(7000002d45054d8) pcs=7000012c3661980
  clk=7000012b7046db8 ci=7000011f45bc560 pn=0 ctx=7000011537bcbb8
kgsccflg=0 llk[1108eefd8,1108eefd8] idx=0
xscflg=80100036 fl2=4200009 fl3=2022008 fl4=0
Frames pfr 110b1e6a0 siz=904 efr 110b1e5d8 siz=840
Cursor frame dump
  enxt: 2.0x00000010
  pnxt: 2.0x00000008  pnxt: 1.0x00000038
kxscphp  11096f118 siz=984 inu=416 nps=416
kxscdfhp 11093b798 siz=984 inu=88 nps=0

只有一个child cursor

回复只看该作者道具举报

Maclean Liu(刘相兵

2^#

发表于 2013-4-19 09:22:12

ORA-07445: 出现异常错误: 核心转储 [kksxsccmp+0428] [SIGSEGV] [Address not mapped to object] [0xE86300987C7B03DA] [] []

stack call

opiosq0=> kksParseCursor=> kkspsc0=> kgscFindCursor

SO: 700001393d32770, type: 4, owner: 7000013932038b8, flag: INIT/-/-/0x00
(session) sid: 1085 trans: 70000132b0227b8, creator: 7000013932038b8, flag: (100041) USR/- BSY/-/-/-/-/-
            DID: 0001-00CD-0004232E, short-term DID: 0001-00CD-0004232F
            txn branch: 0
            oct: 0, prv: 0, sql: 0, psql: 7000002d4649eb0, user: 61/SGPMS
service name: pmdb
O/S info: user: weblogic, term: , ospid: 1234, machine: nxyxweb03
            program:
client info: 10.217.1.27
last wait for 'row cache lock' wait_time=0.000140 sec, seconds since wait started=0
            cache id=b, mode=0, request=3
            blocking sess=0x0 seq=28835
Dumping Session Wait History
   for 'row cache lock' count=1 wait_time=0.000140 sec
            cache id=b, mode=0, request=3
   for 'SQL*Net message from client' count=1 wait_time=0.001515 sec

最近在等 row cache lock  执行的语句是 select seq_d_status_chg.nextval from dual

   SO: 7000011895fe2d8, type: 53, owner: 700001393d32770, flag: INIT/-/-/0x00
   LIBRARY OBJECT LOCK: lock=7000011895fe2d8 handle=7000002d4649eb0 mode=N
   call pin=0 session pin=0 hpc=0000 hlc=0000
   htl=7000011895fe358[7000011892f08b0,7000012b7046e38] htb=70000126ea7ce50 ssga=70000126ea7c808
   user=700001393d32770 session=700001393d32770 count=1 flags=[0000] savepoint=0x516f960c
   LIBRARY OBJECT HANDLE: handle=7000002d4649eb0 mtx=7000002d4649fe0(1) lct=4671 pct=1 cdp=1
   name=select seq_d_status_chg.nextval from dual

回复只看该作者道具举报

返回列表

		自动登录	找回密码
密码			注册