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).



SQL Tuning Advisor报错ORA-00600: internal error code, arguments: [kesqsMakeBindValue:obj],古老的榕树,5-wow.com

郑重声明:本站内容如果来自互联网及其他传播媒体,其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享,并不代表本站赞同其观点和对其真实性负责,也不构成任何其他建议。