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 to [Release 11.2 to 12.1]
Information in this document applies to any platform.


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 ...



Upgrade was performed to


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