Run 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 on MOS that this is a BUG and must be upgraded 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)
##### The screenshot information is as follows:
Applies:
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 Release11.2
Solution will also be implemented in a futurE 10.2 release (10.2.0.5.0 ).