My Oracle Support Banner

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

Last updated on OCTOBER 08, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.0. to 11.2.0.4 [Release 11.2]
Oracle Database Cloud Schema 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
Oracle Database Cloud Exadata Service - Version N/A and later
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:

 

Changes

 E-Business Suite was upgraded to 12.x

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.