ORA-600 [17147] / ORA-600 [KGHFRF] / ORA-600 [KGXAOLDUMP] FROM DBMS_SQLTUNE

(Doc ID 1495400.1)

Last updated on NOVEMBER 13, 2017

Applies to:

Oracle Database - Enterprise Edition
Information in this document applies to any platform.

Symptoms

Customer receives errors during normal operations. Error come from SQL Tuning.

ORA-00600: internal error code, arguments: [17147], [0x02C09F2B8], [], [], [], [], [], [], [], [], [], []

ORA-07445: exception encountered: core dump [kgxAolDump()+157] [SIGSEGV]  [ADDR:0xC0] [PC:0x7BD30B7] [Address not mapped to object] []

 

Call stack can look like:

(for 17147 / kghfrf)
kghfrf kghstack_underflow_internal kghstack_free qsmmixsqltuneanalyzeidx kestsiindexanalyzedrv

(for kgxAolDump)
kkoatVerifyIdxAcc kkeAdjIndexSel kkessc kkeidc kketac kkonxc kkotap kkoiqb kkooqb kkoqbc 

 

Current SQL will either show being run from DBMS_SQLTUNE, or may have the /* SQL Analyze */ hint.

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