Legacy Load ODS Is Ending With Error. - ORA-04036: PGA Memory
(Doc ID 2325791.1)
Last updated on DECEMBER 03, 2019
Applies to:
Oracle Advanced Supply Chain Planning - Version 12.1 and laterInformation 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
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 |
Cause |
Solution |
References |