Blog dedicated to Oracle Applications (E-Business Suite) Technology; covers Apps Architecture, Administration and third party bolt-ons to Apps

Tuesday, June 10, 2008

ORA-04030 during ASCP data pull

Maran pinged me today for error during ASCP Data pull. The MSCPDPW module: Planning Data Pull Worker was erroring out with these errors:

Procedure LOAD_SALES_ORDER(2) started.
Error pulling data from MRP_AP2_SALES_ORDERS_V to MSC_ST_SALES_ORDERS.
ORA-04030: out of process memory when trying to allocate 2136 bytes (kxs-heap-c,qkkele)
ORA-02063: preceding line from ASCP2OLTP
ORA-04030: out of process memory when trying to allocate 2136 bytes (kxs-heap-c,qkkele)
ORA-02063: preceding line from ASCP2OLTP
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+

I went through metalink note 233869.1 Diagnosing and Resolving ORA-4030 errors. The note is quite good and gives good insight. I also went through this presentation from Pythian Group titled Working with Automatic PGA, about which I found from Jonathan Lewis' site. The current setup in the instance was:

sga_max_size = 4G
sga_target = 3G
pga_aggregate_target=2G

I increased pga_aggregate_target=3G by

alter system set pga_aggregate_target=3G;

Data pull completed without issues after this change.
+---------------------------------------------------------------------------+
Executing request completion options...


Output is not being printed because:
The print option has been disabled for this report.


Finished executing request completion options.

+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 10-JUN-2008 10:20:56

+---------------------------------------------------------------------------+
~

4 comments:

Anonymous said...

hi how r u,....i want to start with sql server,but i want to move later on oracle...so i want to know what is the common things between these two product.
as plsql in oracle and transact sql in sql server.is there is any difference among them..

Anonymous said...

what are the common things in sql server and oracle...

tairi said...

my email is thetahir1@yahoo.com
and i am a begginer,so please tell me what should i do.i am job less and i want to select a tool.now my friend told me to do sqlserver and he would arrange a job for me.but i am interested in oracle.but acc to me both are same.working on sql language.one use plsql and other use transact sql...but i thing sql development syntax is same in both product.but let me know from where should i start..if u dont mind sir,,would u be my teacher...

Anonymous said...

both are RDBMS