ORA-600 [qkaffsindex3] or ORA-600 [qkaffsindex5] Raised For SQL Tuning Advisor (Doc ID 2022280.1)

Last updated on MAY 19, 2017

Applies to:

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

Symptoms

For the SQL Tuning Advisor, next error is raised in the alert log for a SQL Analyze job:

ORA-00600: internal error code, arguments: [qkaffsindex3], [], [], [], [], [], [], [], [], [], [], []

- OR -

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


The trace file shows characteristics like below (for an ORA-600 [qkaffsindex3]):

*** 2015-06-18 22:38:41.671
*** SESSION ID:(719.63605) 2015-06-18 22:38:41.671
*** CLIENT ID:() 2015-06-18 22:38:41.671
*** SERVICE NAME:(SYS$USERS) 2015-06-18 22:38:41.671
*** MODULE NAME:(DBMS_SCHEDULER) 2015-06-18 22:38:41.671
*** ACTION NAME:(ORA$AT_SQ_SQL_SW_2818) 2015-06-18 22:38:41.671

ORA-00600: internal error code, arguments: [qkaffsindex3], [], [], [], [], [], [], [], [], [], [], []


----- Current SQL Statement for this session (sql_id=cqqjd10qcu0kf) -----
/* SQL Analyze(323,1) */  < failing sql statement >


----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
0x9ad2bb770 11829 package body SYS.DBMS_SQLTUNE_INTERNAL
0x9bb75d308 7 SYS.WRI$_ADV_SQLTUNE
0x9ae730318 601 package body SYS.PRVT_ADVISOR
0x9ae730318 2678 package body SYS.PRVT_ADVISOR
0x9a7d41fb0 241 package body SYS.DBMS_ADVISOR
0x9bf2f6a10 821 package body SYS.DBMS_SQLTUNE
0x99fc01fd8 4 anonymous block


----- Call Stack Trace -----
... qkaffsindex qkatab qkajoi qkaqkn qkadrv qkadrv opitca kksFullTypeCheck rpiswu2 kksLoadChild kxsGetRuntimeLock kksfbc kkspsc0 kksParseCursor opiosq0 kpooprx kpoal8 opiodr ... 


Note that the trace file shows:

 

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