ORA-04030: out of process memory when trying to allocate bytes

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)."

Published: 14 May 2007

When I run a multi-threaded process in Oracle Apps 11i, it fails with the error "ORA-04030: out of process memory...

Step 2 of 2:

You forgot to provide an Email Address.

This email address doesn’t appear to be valid.

This email address is already registered. Please log in.

You have exceeded the maximum character limit.

Please provide a Corporate Email Address.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.

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.

PGA Tour teams up with AWS to improve fan engagement during tournaments

PPGA (plastic pin grid array)

FC-PGA (flip chip-pin grid array)

PGA Ryder Cup 2010 golf tournament at the Celtic Manor Hotel