ORA-600 [kestsacAddIndCtx-2] During "SYS_AUTO_SQL_TUNING_TASK" (Doc ID 2032282.1)

Last updated on JULY 20, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 to 12.1.0.1 [Release 11.2 to 12.1]
Information in this document applies to any platform.

Symptoms

Alert log reports next error during database "SYS_AUTO_SQL_TUNING_TASK" automatic job

ORA-00600: internal error code, arguments: [kestsacAddIndCtx-2], [0x9FFFFFFFFCBB4E60]

 
The trace file shows a sql analyze comment for the query and call stack functions like:

----- Current SQL Statement for this session (sql_id=...) -----
/* SQL Analyze(528,1) */ SELECT ...


----- Call Stack Trace -----
... kestsacAddIndCtx kkoatGetIndCtx kkoatStatsCollectTab kkoatStatsCollect kkoipt kkoqbc apakkoqb apaqbdDescendents apaqbdList apaqbdDescendents apaqbdList apaqbdDescendents apaqbd apadrv opitca kksFullTypeCheck rpiswu2 kksLoadChild kxsGetRuntimeLock kksfbc kkspsc0 kksParseCursor opiosq0 kpooprx kpoal8 opiodr kpoodrc rpiswu2 kpoodr upirtrc kpurcsc kpuexec OCIStmtExecute qksanExecSql qksanAnalyzeSql qsmmixProcessQuery qsmmixSqlTuneAnalyzeIdx kestsiIndexAnalyzeDrv kestsTuneSqlDrv kesaiExecAction kesaiTuneSqlDrv ...

 

Changes

Upgrade was performed to 11.2.0.4.

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