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:

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 Execute

  12.1.0.2 800 MB 13 MB
  12.2.0.1 300 MB 11 MB

  When:
  --------
  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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.