Q
Problem solve Get help with specific problems with your technologies, process and projects.

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

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.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close