PG&C Compliance Calculation Report: High Memory Utilization (ORA-04030: Out Of Process Memory Errors) (Doc ID 1548953.1)

Last updated on AUGUST 08, 2017

Applies to:

Oracle Agile Product Governance and Compliance - Version 9.3.1.1 and later
Information in this document applies to any platform.
***Checked for relevance on 23-Dec-2014***

Symptoms

On : 9.3.1.1 version, Rollup (PGC)

When attempting to calculate compliance for very large BOM
the following error occurs.

ERROR
-----------------------
Errors in file D:\ORACLE\APP\diag\rdbms\agile9\agile9\trace\agile9_ora_5880.trc (incident=144303):
ORA-04030: out of process memory when trying to allocate 82456 bytes (pga heap,control file i/o buffer)
ORA-04030: out of process memory when trying to allocate 16328 bytes (koh-kghu call ,pmucalm coll)

The issue can be reproduced at will with the following steps:


1. Run Compliance Rollup at system level
2. Log has ORA-04030 errors
3. Run Calculate compliance at item level
4. Fails with error ORA-04030



Changes

 

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