ORA-04030 occurred while executing PLSQL procedure

(Doc ID 1953999.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 11.2 to 12.1]
Information in this document applies to any platform.


ORA-04030 occurred while executing PLSQL code

ORA-04030: out of process memory when trying to allocate 8528 bytes (pga heap,kgh stack)


Trace Files

The incident trace file confirms:

Oracle Database 11g Enterprise Edition Release - 64bit Production


----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
c000000c8f030c50       494  package body TC.PROC2
c000000c8f030c50       599  package body TC.PROC2
c000000cb45c1d18        92  package body TC.PROC1



*** 2014-11-13 20:05:08.462
57%   18 GB, 2251612 chunks: "kgh stack                 "  
         pga heap        ds=6000000000059110  dsprt=0000000000000000
37%   12 GB, 11726744 chunks: "permanent memory          "  
         callheap        ds=9ffffffffb4f0108  dsprt=600000000005eb70
 6% 1782 MB, 321681 chunks: "free memory               "  
         pga heap        ds=6000000000059110  dsprt=0000000000000000


----- Call Stack Trace -----
opipls()+9424        call     kghstack_alloc()     6000000000059400 ?
opipls()+4256        call     opiexe()             9FFFFFFFFFFE3800 ?

Summary - The following must be true to confirm the bug:
 1. RDBMS release
 2. ORA-04030 due to "kgh stack" allocation.
 3. Multiple opipls() calls on the stack.


Database was upgraded to


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