DBMB2C - Legacy Load ODS Is Ending With Error. - ORA-04036: PGA Memory

(Doc ID 2325791.1)

Last updated on NOVEMBER 07, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.1 and later
Information in this document applies to any platform.

Symptoms

On Any Release


PROBLEM
-------------
1. Error in ODS Load
MSCPDCW: Planning ODS Load Worker
+---------------------------------------------------------------------------+

Current system time is 18-OCT-2017 11:18:00

+---------------------------------------------------------------------------+

**Starts**18-OCT-2017 11:18:01
**Ends**18-OCT-2017 11:18:49
ORA-00039: error during periodic action
ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT

.....
************************************************************
18-OCT 11:18:05 : MSC_DL_TASK_START_PARTIAL (PROCEDURE=MSC_CL_ITEM_ODS_LOAD.LOAD_ITEM)
18-OCT 11:18:47 : ORA-00039: error during periodic action
ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT
18-OCT 11:18:47 : ORA-00039: error during periodic action
ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT
18-OCT 11:18:49 : Sending message :
            -9999999 to monitor.
18-OCT 11:18:49 : Error_Stack...
18-OCT 11:18:49 : ORA-00039: error during periodic action
ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT

18-OCT 11:18:49 : Error_Backtrace...
18-OCT 11:18:49 : ORA-06512: at "APPS.MSC_CL_COLLECTION", line 3618
ORA-06512: at "APPS.MSC_CL_COLLECTION", line 3843


2. Alert log shows
2017-10-18 11:18:47.082000 -05:00
Errors in file .... /incident/incdir_73628/DBMB2C_ora_9750_i73628.trc:
ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT
ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT
Dumping diagnostic data in directory=[cdmp_20171018111847], requested by (instance=1, osid=9750), summary=[incident=73630].


3. apscheck shows in section 9.2
pga_aggregate_limit 1048576000
pga_aggregate_target 524288000


STEPS
--------
Run Legacy collections to load data


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