ORA-600  , ORA-7445 Kghfrh_internal Or ORA-600 [KGHALO4] After Upgrade To 18.104.22.168
Last updated on NOVEMBER 28, 2016
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 and later
Information in this document applies to any platform.
You are encountering ORA-600 internal error 
With event 10235 set to level 2, the error becomes ORA-7445 core dump [kghfrh_internal()+411]
sometimes followed by ORA-600 internal error [KGHALO4], [0x...], 
Stack trace is similar to:
... kghfrh_internal kghfrh kksCompileCallNotifier kscdnfy ksudlc kssdel ksupop kksPopCompileCall ...
Current SQL shows multiple views being accessed via in-line views:
SELECT ... FROM (SELECT ... FROM (SELECT ...
or explicit use of ANSI JOIN keywords like LEFT OUTER JOIN
You recently upgraded your database from 10.2 to 126.96.36.199.0
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