ORA-600  , ORA-7445 Kghfrh_internal Or ORA-600 [KGHALO4] After Upgrade To 18.104.22.168
(Doc ID 1471032.1)
Last updated on AUGUST 04, 2018
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
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