ORA-00600 [16608] from Automatic SQL tuning Task

(Doc ID 1466129.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Standard Edition - Version 11.2.0.2 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.
***Checked for relevance on 12-Dec-YYYY***

Symptoms

You are performing automatic SQL tuning Tasks and it intermittently fails with the following error:

ORA-00600:[16608], [4], [2],[0x358964A40]


The trace file shows:

----- Current SQL Statement for this session (sql_id=8guhdz3v2xva4) -----
/* SQL Analyze(267,1) */ select ...,
from
<table(s)>
where  ( <where clause> )
group by ...

----- PL/SQL Stack -----
----- PL/SQL Call Stack ----- object      line  object
 handle    number  name
0xc5ed3588     11816  package body SYS.DBMS_SQLTUNE_INTERNAL
0xeb8300d8         7  SYS.WRI$_ADV_SQLTUNE
0x11e7d02a0       587  package body SYS.PRVT_ADVISOR
0x11e7d02a0      2655  package body SYS.PRVT_ADVISOR
0x11d661e38       241  package body SYS.DBMS_ADVISOR
0x1017b3af0       821  package body SYS.DBMS_SQLTUNE
0xd65c1448         4  anonymous block

The problem occurs for different queries, but the queries show the same call stack.

The call stack is similar to:

... kglsscn <- kqlsscn <- kkdcicf <- kkqctdrvGBP <- kkqgbpTravChkTran <- qksqbApplyToQbc <- kkqctdrvTD <- kkqgbpdrv <- kkqdrv ...

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