SQL Tuning Advisor一个错误ORA-00600: internal error code, arguments: [kesqsMakeBindValue:obj]

跑SELECT dbms_sqltune.report_tuning_task(:tuning_task) FROM dual;  错误消息,如下面:



ORA-00600: internal error code, arguments: [kesqsMakeBindValue:obj], [], [],

[], [], [], [], []

ORA-06512: at "SYS.PRVT_ADVISOR", line 1624

ORA-06512: at "SYS.DBMS_ADVISOR", line 186

ORA-06512: at "SYS.DBMS_SQLTUNE", line 1008

ORA-06512: at line 8

##################

经MOS上确认,此为BUG。须要升级到10.2.0.5PSU或者11.2

文章 :

Tuning Advisor terminates with ORA-600[kesqsMakeBindValue:obj] or ORA-600 [kesutlGetBindValue-2] (文档 ID 605178.1)

ORA-600 [kesqsmakebindvalue:obj] (文档 ID 756752.1)   

#####截取点信息例如以下:

Applies to:

Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 11.1.0.7

This problem can occur on any platform.

Symptoms



    Tuning Advisor terminates with ORA-600[kesqsMakeBindValue:obj] or ORA-600 kesutlGetBindValue-2]

    ORA-00600: internal error code, arguments: [kesqsMakeBindValue:obj], [], [], [], [], [], [], []

Known Bugs

    NB    Bug    Fixed    Description

        6854919    10.2.0.5, 11.2.0.1    Dump / OERI from DBMS_SQLTUNE

####

FIX

    Fixed in Oracle RDBMS Release 11.2

    Solution will also be implemented in a future 10.2 release (10.2.0.5.0).

版权声明:本文博主原创文章。博客,未经同意不得转载。

上一篇:音视频处理之FFmpeg+SDL+MFC视频播放器20180411


下一篇:iOS中Block使用探索