When I run a multi-threaded process in Oracle Apps 11i, it fails with the error "ORA-04030: out of process memory...
when trying to allocate 16396 bytes (koh-kghu sessi,pl/sqlvc2)." Through Metalink research I found out that the recommended setting for the pga_aggregate_target for an Oracle Applications 11i environment is between 1-20 GB. We have allocated 1GB to pga_aggregate_target in Patch environment. The IS-STOA server has 24GB memory. How to avoid this error?
The information you found on Metalink is correct. You need to have a correct setting for the PGA_AGGREGATE_TARGET initialization parameter. The big question becomes, what is the correct setting? Unfortunately, I cannot answer that question. However, I do have a white paper on my Web site titled "Tuning PGA in Oracle 9i" which shows you how to successfully determine the value for this parameter.
Dig Deeper on Oracle applications implementation and upgrades
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.