ORA-04030 occurred while executing PLSQL procedure (Doc ID 1953999.1)

Last updated on NOVEMBER 28, 2016

Applies to:

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

Symptoms

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 11.2.0.4.0 - 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

 

=======================================
TOP 10 MEMORY USES FOR THIS PROCESS
---------------------------------------

*** 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 11.2.0.4.0
 2. ORA-04030 due to "kgh stack" allocation.
 3. Multiple opipls() calls on the stack.
 

Changes

Database was upgraded to 11.2.0.4

Cause

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