performance / tuning tips. to the point.                
 
About Us | Site Map | Privacy
Disclaimer | Feedback
About RSS Feed | Useful Links
Search Partner Links
Original Blog
Add to My Yahoo!
Google Reader or Homepage
del.icio.us performancewiki.com Latest Items


© 2005-2009 PerformanceWiki.com
All Rights Reserved.


Performance Related Oracle Error Codes and Resolutions



04030, 00000, out of process memory when trying to allocate xxx bytes

On Windows, to allocate more memory for additional extproc.exe processes (spawned by oracle.exe), 
lower the orastack values for oracle.exe and the listener.  When memory is low, you may get 
"04030, 00000, out of process memory when trying to allocate %s bytes (%s,%s)" error.
This is caused by Operating system process private memory has been exhausted. 
To help solve this problem, lower the stack memory allocation for oracle.exe and the 
listener by running the following command:

To set:
C:\oracle9i\bin\orastack oracle.exe 500000 
C:\oracle9i\bin\orastack tnslsnr.exe 500000
(Default is 1MB)
To query:
C:\oracle9i\bin\orastack oracle.exe 
C:\oracle9i\bin\orastack tnslsnr.exe

Expect output as follows (what you want after the setting):

D:\oracle\ora92\bin>orastack oracle.exe

Dump of file oracle.exe

Current Reserved Memory per Thread  = 500000
Current Committed Memory per Thread = 4096

D:\oracle\ora92\bin>orastack tnslsnr.exe

Dump of file tnslsnr.exe

Current Reserved Memory per Thread  = 500000
Current Committed Memory per Thread = 4096

Google
 
Web www.performancewiki.com
www.ibm.com www.digg.com