生产库某一台数据库在某个时段忽然报错，类似如下：
DDE: Problem Key 'ORA 600 [17059]' was completely flood controlled (0x6)Thu May 30 19:17:57 2019
DDE: Problem Key 'ORA 600 [17059]' was completely flood controlled (0x6)
Further messages for this problem key will be suppressed for up to 10 minutes
并开始产生大量的trc文件，抽取某一个trc文件发现里面是一条插入审计日志的语句，具体trc请看附件：
insert into sys.aud$( sessionid,entryid,statement,ntimestamp#, userid,userhost,terminal,action#,returncode, logoff$lread,logoff$pread,logoff$lwrite,logoff$dead, logoff$time,comment$text,spare1,clientid,sessioncpu,proxy$sid,user$guid, instance#,process#,auditid,dbid) values(:1,:2,:3,SYS_EXTRACT_UTC(SYSTIMESTAMP), :4,:5,:6,:7,:8, :9,:10,:11,:12, cast(SYS_EXTRACT_UTC(systimestamp) as date),:13,:14,:15,:16,:17,:18, :19,:20,:21,:22)
ORA 600 [17059]通常是数据库游标数量超过32768报错，如trace中可以看到子游标数量已经达到32768
ChildTable: size='32768' Child: id='0' Table=bfe52f60 Reference=bfe529b0 Handle=7eed8cb8 Child: id='1' Table=bfe52f60 Reference=bfbe65a0 Handle=7e4f1d40 ...省略 Child: id='32766' Table=dfa37f20 Reference=a3140fc8 Handle=7985cca8 Child: id='32767' Table=dfa37f20 Reference=a3141300 Handle=6f5527e8
大量Bind mismatch：
Child Node: 0 ID=40 reason=Bind mismatch(22) size=4x4 bind position: 12 original oacflg: 24 original oacmxl: 32 upgradeable new oacmxl: 128 Child Node: 32767 ID=40 reason=Bind mismatch(22) size=4x4 bind position: 12 original oacflg: 24 original oacmxl: 32 upgradeable new oacmxl: 128
这个是由Oracle BUG引起，看到您的数据库版本还是11201，强烈建议升级并安装最新PSU，目前没有其他解决方案。暂时不能升级的话，建议定期清理trace文件。
评论
有用 0
墨值悬赏