My Oracle Support Banner

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

Last updated on OCTOBER 08, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 to 12.1.0.1 [Release 11.2 to 12.1]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
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 <SCHEMA_NAME>.<PACKAGE_NAME2>
c000000c8f030c50       599  package body <SCHEMA_NAME>.<PACKAGE_NAME2>
c000000cb45c1d18        92  package body <SCHEMA_NAME>.<PACKAGE_NAME1>

 

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

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
Changes
Cause
Solution
References


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