暂无图片
暂无图片
暂无图片
暂无图片
暂无图片

ORA-00600 [723]问题分析和处理

1、情况介绍

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

看到问题后询问用户近期业务是否有影响,用户反馈这些时段均有人反馈会话被断开,需要重新登录才能继续使用,该问题不定时出现。

2、问题排查分析

查询mos

(Doc ID 1379577.1)

,发现723为pga中内存泄漏问题,参数a代表代表会话注销时候pga使用大小,b代表内存超出泄漏时候会话断开大小;于是进一步把日志拷贝到本地分析,第一个a值始终为132608字节:

根据mos的介绍:

    CAUSE
    The issue has been investigated in the unpublished
    Bug 9093161 - GETTING ORA-600 [723], [105312] WHILE SHUTTING DOWN DB
    closed as a duplicate of unpublished
    Bug 8676674 - ARCH REPORTED ORA-00600:[723] DURING SWITCHOVER


    SOLUTION
    There is no patch available for 8676674 on 11.2.0.1, but this has been fixed in the 11.2.0.2 patchset


    Please refer to
    Note 1179583.1 - 11.2.0.2 Patch Set - List of Bug Fixes by Problem Type


    If 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进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

    评论