ORA-600 [Qkaffsindex5] On Select From MGMT_TARGETS, MGMT_METRICS (Doc ID 1088484.1)

Last updated on FEBRUARY 07, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.1 [Release 11.2]
Information in this document applies to any platform.
***Checked for relevance on 03-Jun-2013***

Symptoms

Error ORA-600: [qkaffsindex5] is reported when the Enterprise Manager generated select statement is executed. 

SELECT DISTINCT T.TARGET_TYPE
FROM MGMT_TARGETS T, MGMT_METRICS M
WHERE T.TARGET_TYPE = M.TARGET_TYPE
AND METRIC_NAME = 'Response'
AND METRIC_COLUMN = 'Status'


The trace file for the ORA-600 [qkaffsindex5] will have a call stack similar to the one listed below.

skdstdst()+36
ksedst1()+98
ksedst()+34
dbkedDefDump()+2736
ksedmp()+36
ksfdmp()+64
dbgexPhaseII()+1764
dbgexProcessError()+2279
dbgeExecuteForError()+83
dbgePostErrorKGE()+1615
dbkePostKGE_kgsf()+63
kgeadse()+383
kgerinv_internal()+45
kgerinv()+33
kgeasnmierr()+143
qkaffsindex()+3224
qkatab()+10361
qkajoi()+719
qkaqkn()+1095
qkadrv()+1052
qkadrv()+8866
opitca()+2077
kksFullTypeCheck()+29
rpiswu2()+1541
kksLoadChild()+7565
kxsGetRuntimeLock()+1992
kksfbc()+13436
kkspbd0()+617
kksParseCursor()+667
opiosq0()+1915


Once the error has been encountered, executing command EXPLAIN PLAN FOR on the failing select statement will normally reproduce the ORA-600 [qkaffsindex5] error.

SQL> explain plan for (SELECT DISTINCT T.TARGET_TYPE FROM MGMT_TARGETS T, MGMT_METRICS M WHERE T.TARGET_TYPE = M.TARGET_TYPE AND METRIC_NAME = 'Response' AND METRIC_COLUMN = 'Status');

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


Deleting the statistics on the two tables involved will allow the statement to be executed without error.  This can be used as a short term workaround but normally the error will return once the automatic statistics job runs and gathers statistics on the tables.

SQL> exec DBMS_STATS.DELETE_TABLE_STATS ('SYSMAN','MGMT_TARGETS');
SQL> exec DBMS_STATS.DELETE_TABLE_STATS ('SYSMAN','MGMT_METRICS');

Changes

The error is specific to the the 11.2.x release so a common scenario is a recent upgrade to the 11.2.x release.

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