ORA-04030 when recompiling large PLSQL packages (after upgrade to E-Business Suite 12.x)

(Doc ID 1466637.1)

Last updated on NOVEMBER 28, 2016

Applies to:

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

Symptoms

The following PGA memory consumption symptoms were observed when using E-Business Suite to 12.x

Example   
SQL> alter package APPS.XLA_00707_AAD_S_000011_PKG compile;
SQL> alter package APPS.XLA_00707_AAD_S_000011_PKG compile body;

ORA-04030: out of process memory when trying to allocate 4064 bytes (PLS CGA hp,pdzdM80_Allocate_Block)

SQL> select count(*) line from dba_source

     where owner='APPS' and name ='XLA_00707_AAD_S_000011_PKG';

      LINE
----------
    435996   

  "pdzdM80_Allocate_Block    "
  "pdz2M87_Allocate_Permanen "
  "pdz7M87_Make              "
  "pdz8Mz2_Make              "


Example:

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

*** 2012-03-22 13:15:12.324
20%  194 MB, 49991 chunks: "pdzdM80_Allocate_Block    "  PL/SQL
         PLS CGA hp      ds=1109d7730  dsprt=1100f8468
17%  171 MB, 43919 chunks: "pdz2M87_Allocate_Permanen "  PL/SQL
         PLS CGA hp      ds=1109d7730  dsprt=1100f8468
14%  142 MB, 36337 chunks: "pdz7M87_Make              "  PL/SQL
         PLS CGA hp      ds=1109d7730  dsprt=1100f8468
10%  101 MB, 25852 chunks: "pdz8Mz2_Make              "  PL/SQL
         PLS CGA hp      ds=1109d7730  dsprt=1100f8468

...

 

Changes

 E-Business Suite was upgraded to 12.x

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