ORA-00600 [qkaffsindex5] from SQL Tuning Advisor Job (Doc ID 1462688.1)

Last updated on MAY 25, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.

Symptoms

when SQL Tuning Advisor Job is running , the following error occurs.

ERROR
-----------------------
ORA-00600: internal error code, arguments: [qkaffsindex5], [], [], [], [], [], [], [], [], [], [], []

 

Stack Trace contains : qkaffsindex qkatab qkajoi qkaqkn qkadrv qkadrv opitca kksFullTypeCheck rpiswu2 kksLoadChild

 

*** CLIENT ID:() Time_Stamp
*** SERVICE NAME:(SYS$USERS) Time_Stamp
*** MODULE NAME:(DBMS_SCHEDULER) Time_Stamp
*** ACTION NAME:(ORA$AT_SQ_SQL_SW_15870) Time_Stamp

ORA-600: internal error code, arguments: [qkaffsindex5], [], [], [], [],[], [], [], [], [], [], []

========= Dump for incident 2185520 (ORA-600 [qkaffsindex5]) ========

dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3,mask=0x0)
----- Current SQL Statement for this session (sql_id=gbt7dwtd7y0fk) -----
/* SQL Analyze(1180,1) */ SELECT PROGRAM, SESSION_ID FROM AD_TASK_TIMING
GROUP BY PROGRAM, SESSION_ID ORDER BY PROGRAM, SESSION_ID DESC
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
0x271a07500 11816 package body SYS.DBMS_SQLTUNE_INTERNAL
0x234b8e650 7 SYS.WRI$_ADV_SQLTUNE
0x29d37baf0 587 package body SYS.PRVT_ADVISOR
0x29d37baf0 2655 package body SYS.PRVT_ADVISOR
0x271a98468 241 package body SYS.DBMS_ADVISOR
0x271a7a360 821 package body SYS.DBMS_SQLTUNE
0x234a4d488 4 anonymous block

 

As per the Output from DBA_AUTOTASK_JOB_HISTORY :

- ORA$AT_OS_OPT_SY_n stands for auto optimizer stats collection

- ORA$AT_SA_SPC_SY_n stands for auto space advisor

- ORA$AT_SQ_SQL_SW_n stands for sql tuning advisor

 

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