1748169 Members
4273 Online
108758 Solutions
New Discussion юеВ

Re: ORA-04030

 
Juergen Nagel
New Member

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 4
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.