My Oracle Support Banner

ORA-00600 [16608] from Automatic SQL tuning Task (Doc ID 1466129.1)

Last updated on AUGUST 04, 2018

Applies to:

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


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


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.