Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
cancel
Showing results for 
Search instead for 
Did you mean: 

ORA-04030

Juergen Nagel
Occasional Visitor

ORA-04030

Hallo,

I have touble with a Oracle 8.0.6 Database.
ORA-04030
out of process memory when trying to allocate .....

What can i do?

Thanks
4 REPLIES
Dan Hetzel
Honored Contributor

Re: ORA-04030

Hi,

What are the values of kernel parameters:
maxssiz
maxtsiz
shmmax
shmseg
swapmem_on

Dan
Everybody knows at least one thing worth sharing -- mailto:dan.hetzel@wildcroft.com
Vincente Fernandes
Valued Contributor

Re: ORA-04030

Oracle has a executable called "errmsg". errmsg ORA 04030, you may have to check the exact syntax. Below are the details.

Error numbers from 4030 to 4039 are reserved for KGH* (heap manager).
04030, 00000, "out of process memory when trying to allocate %s bytes (%s,%s)"
*Cause: Operating system process private memory has been exhausted
*Action:
You may have to refer to oracle manual for more details.
John Palmer
Honored Contributor

Re: ORA-04030

Hi,

ORA-04030 is caused when your 'slave' oracle process (not any of the server processes) gets an error when calling malloc to obtain more memory.

There appear to be several causes including Oracle bugs and memory leaks. You should also ensure that the kernel parameter maxdsiz is appropriate (the default is 64Mb, try 128Mb at least) and that your 'ulimit' is set to this value.

If the above don't apply then I suggest that you raise a call with Oracle support.

Regards,
John
CHRIS ANORUO
Honored Contributor

Re: ORA-04030

Increase the values of maxtsiz, maxdsiz and shmmax to 1gb. Your swapmem_on should be set to 1(enabled state). bufpages and nbuf should be set to zero for dynamic allocation of memory pages.
When We Seek To Discover The Best In Others, We Somehow Bring Out The Best In Ourselves.