ORA-00600: Internal Error Code, Arguments: [kghuclientasp_03] running SYS_AUTO_SQL_TUNING_TASK (Doc ID 1915817.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 and later
Information in this document applies to any platform.

Symptoms

ORA-600 [KGHUCLIENTASP_03] reported after SYS_AUTO_SQL_TUNING_TASK has just finished.

all others occur in the job queue process running SYS_AUTO_SQL_TUNING_TASK but not every SYS_AUTO_SQL_TUNING_TASK fails.

----- SQL Statement (None) -----
Current SQL information unavailable - no cursor.

----- Call Stack Trace -----

$cold_kghuclientasp kohdee kohdee kohdee kohedud kohedu kohugc kokgugc2

After set the following events in pfile/spfile, new errors reported :

event = "10235 trace name context forever, level 65538"
event = "10501 trace name context forever, level 4100"
event = "600 trace name heapdump level 536875012"

ORA-00600: internal error code, arguments: [kghufree_04], [0x9FFFFFFFFBD26A00], [0], [0], [0], [], [], [], [], [], [], []
ORA-13236: internal error in R-tree processing: [Snapshot too old or Recursive fetch error]
ORA-13234: failed to access R-tree-index table [MDRT Table]
ORA-29400: data cartridge error
ORA-00942: table or view does not exist

----- PL/SQL Call Stack -----
object line object
handle number name
c0000000dc356978 7294 package body SYS.DBMS_SQLTUNE_INTERNAL
c0000000c75580e0 8 SYS.WRI$_ADV_SQLTUNE
c0000000dc403af0 545 package body SYS.PRVT_ADVISOR
c0000000dc368c28 702 package body SYS.DBMS_SQLTUNE

----- Call Stack Trace -----

$cold_kghufree kohfrem kohfrr kpmfree OCIMemoryFree mdrtfree mdrtpq mdrtft

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