Encountering ORA-00600 when we try to tune the sql query

Apr 21, 2014 5:28AM

Hi,

Facing ORA-00600 error when we are trying to tune the sql query. Could you some one please help me on this ?

Oracle version : Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

********** Error ***********

BEGIN DBMS_SQLTUNE.execute_tuning_task(task_name => '136489_136489_cu3bkmxqtncum'); END;

*

ERROR at line 1:

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 1

********* Trace file ***********

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

With the Partitioning, Data Mining and Real Application Testing options

ORACLE_HOME = /home/oracle/product/10.2.0

SQL Performance (MOSC)