Explain Plan for Query Errors with 'ORA-00600: internal error code, arguments: [KGL-heap-size-exceeded]'
(Doc ID 2469727.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Standard Edition - Version 12.1.0.2 and laterInformation in this document applies to any platform.
Symptoms
- Explain plan for query errors with ORA-00600: internal error code, arguments: [KGL-heap-size-exceeded]:
ORA-00600: internal error code, arguments: [KGL-heap-size-exceeded], [0xE1EB930A0]
--OR if threshold is higher
DB Version Memory Allocation
Explain Execute12.1.0.2 800 MB 13 MB
12.2.0.1 300 MB 11 MBWhen:
--------
explain plan for
SELECT /* add hint to hard parse */ *
FROM (
SELECT... - The following call stack is produced:
kglLargeHeapWarning <- kksCalculateHeapsSi <- kksEndOfCompile <- opitca <- kksFullTypeCheck
<- rpiswu2 <- kksLoadChild <- kxsGetRuntimeLock <- kksfbc <- kkspsc0
<- kksParseCursor
Cause
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
Symptoms |
Cause |
Solution |
References |