Ask the Expert

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

    Requires Free Membership to View

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.

This was first published in May 2007

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.