Execute Select dbms_sqltune.report_tuning_task (: tuning_task) from dual; The error message is as follows:
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
##################
Confirmed by MoS, this is a bug, need to upgrade to 10.2.0.5PSU or 11.2
Article:
Tuning Advisor terminates with Ora-600[kesqsmakebindvalue:obj] or ORA-600 [kesutlGetBindValue-2] (document ID 605178.1)
ORA-600 [Kesqsmakebindvalue:obj] (document 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'll also is implemented in a futurE 10.2 release (10.2.0.5.0).