1、情况介绍
今日到用户这里做巡检工作,发现一台服务器有大量的ora-00600 723报错信息,如下:

看到问题后询问用户近期业务是否有影响,用户反馈这些时段均有人反馈会话被断开,需要重新登录才能继续使用,该问题不定时出现。
2、问题排查分析
查询mos
(Doc ID 1379577.1)
,发现723为pga中内存泄漏问题,参数a代表代表会话注销时候pga使用大小,b代表内存超出泄漏时候会话断开大小;于是进一步把日志拷贝到本地分析,第一个a值始终为132608字节:

根据mos的介绍:
CAUSEThe issue has been investigated in the unpublishedBug 9093161 - GETTING ORA-600 [723], [105312] WHILE SHUTTING DOWN DBclosed as a duplicate of unpublishedBug 8676674 - ARCH REPORTED ORA-00600:[723] DURING SWITCHOVERSOLUTIONThere is no patch available for 8676674 on 11.2.0.1, but this has been fixed in the 11.2.0.2 patchsetPlease refer toNote 1179583.1 - 11.2.0.2 Patch Set - List of Bug Fixes by Problem TypeIf possible, apply the latest patch-set (11.2.0.3 or 11.2.0.4) where the issue is fixed.Workaround:Set the following in init.ora for example to disable space leaks less than 9000 bytes:event = "10262 trace name context forever, level 9000"and stop and restart the database.
3、问题处理
1、调整10262参数
2、更新最新11.2.0.4的补丁,我这里直接打到22年7月份psu
3、调大pga内存
文章转载自数据库技术加油站,如果涉嫌侵权,请发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。




