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

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 11.1.0.7
This problem can occur on any platform.

Symptoms

ORA-00600: internal error code, arguments: [kesqsMakeBindValue:obj], [], [], [], [], [], [], []
Current SQL statement for this session:
DECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :mydate; broken BOOLEAN := FALSE; job_name VARCHAR2(30
) := :job_name; job_subname VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start TIMESTAMP WITH TIME ZO
NE := :job_start; window_start TIMESTAMP WITH TIME ZONE := :window_start; window_end TIMESTAMP WITH TIME ZONE := :window_end; BE
GIN begin dbms_sqltune.execute_tuning_task('SQL_TUNING_1214510425413'); end; :mydate := next_date; IF broken THEN :b := 1; ELSE :
b := 0; END IF; END;

----- PL/SQL Call Stack -----
object line object
handle number name
0x5127f764 3584 package body SYS.DBMS_SQLTUNE_INTERNAL
0x4cba41d4 8 SYS.WRI$_ADV_SQLTUNE
0x517127e4 1535 package body SYS.PRVT_ADVISOR
0x517127e4 1618 package body SYS.PRVT_ADVISOR
0x4ee9b3f8 186 package body SYS.DBMS_ADVISOR
0x50198bb4 1008 package body SYS.DBMS_SQLTUNE
0x4d391960 1 anonymous block 
CALL STACK
----------
-- 10.1.0.x (ORA-00600: [kesutlGetBindValue-2])
kesutlGetBindValue kesatmGetSqlBinds kesatmGetSqlStmt kesaiInitProgress ...

-- 10.2.0.x (ORA-00600 [kesqsMakeBindValue:obj])
kesqsMakeBindValue kesatmGetSqlBinds kesatmGetSqlStmt kesaiInitProgress ...

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms