performance / tuning tips. to the point.
|
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
|
|
|
|