
	Home > Ask the Oracle Database / Applications Experts > Oracle database design and architecture Questions & Answers > ORA-04030: out of process memory when trying to allocate bytes

Ask The Oracle Expert: Questions & Answers

EMAIL THIS

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

EXPERT RESPONSE FROM: Brian Peasland

		Pose a Question

		Other Oracle Categories

		Meet all Oracle Experts
		Become an Expert for this site

Oracle tips, scripts, and expert advice

Digg This! StumbleUpon Del.icio.us

QUESTION POSED ON: 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 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?

Digg This!

StumbleUpon

Del.icio.us

RELATED CONTENT

	Oracle database design and architecture
	Can I download DBCA for Oracle Express Edition?
	How to recreate an Oracle index in a new schema with the CREATE command
	Using Oracle Universal Installer to install Oracle with Pro*C
	Defining Oracle database repository vs. information repository
	Can I create multiple schemas in Oracle for one user?
	ORA-12514 error when connecting to the Oracle database through Toad
	Solving the ORA-00904 error: invalid identifier in Oracle
	How to tune SQL UPDATE statements for an Oracle 10g upgrade
	Will queries run slower in a smaller Oracle buffer cache?
	Using a database link to connect two Oracle apps instances

Oracle database performance problems and tuning

Oracle New Year's resolutions, part 1: Advice for navigating 2009

Solving common Oracle errors guide

Oracle 11g data compression

Varchar or number for better performance?

Do statistics on SYS-owned objects hurt performance in 10g?

Inside the Oracle 11g SQL Performance Advisor, part 1

Inside the Oracle 11g SQL Performance Advisor, part 2

Difference between driving table and driver table in Oracle

Best design for E-Business Suite on hard drive

Using the cost-based optimizer to improve Database 10g performance

Oracle applications implementation and upgrades

Oracle brings Fusion Middleware into the modern age

Oracle's Identity Manager features new integration architecture

Oracle Application Integration Architecture: Where it is going?

OAUG president talks Collaborate '09 and the future of Oracle apps

Special Report: Collaborate '09

Oracle bolsters application integration lineup with new AIA packs

New OAUG chief riffs on Fusion, Exadata and recession planning

Oracle New Year's resolutions, part 2: GRC tips and customer resolutions revealed

Oracle's Fusion Applications: Way behind or right on track?

Oracle abuzz over Beehive collaboration platform, other updates at OpenWorld 2008

Oracle applications implementation and upgrades Research

RELATED RESOURCES

2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems

Search Bitpipe.com for the latest white papers and business webcasts

Whatis.com, the online computer dictionary

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.

Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.

Browse our Expert Advice
Operating Systems IT Management Networking Database	Security Servers and Storage Applications and Development Career Center

Oracle White Papers: Fusion Middleware

SEARCH

TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.


TechTarget Corporate Web Site \| Media Kits \| Site Map All Rights Reserved, Copyright 2003 - 2009, TechTarget \| Read our Privacy Policy