topic Re: ORA-04030 in Operating System - HP-UX

ORA-04030

Juergen Nagel — Tue, 28 Nov 2000 07:45:49 GMT

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

Re: ORA-04030

Dan Hetzel — Tue, 28 Nov 2000 08:20:59 GMT

Hi,

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

Dan

Re: ORA-04030

Vincente Fernandes — Tue, 28 Nov 2000 08:22:30 GMT

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.

Re: ORA-04030

John Palmer — Tue, 28 Nov 2000 09:07:39 GMT

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

Re: ORA-04030

CHRIS_ANORUO — Tue, 28 Nov 2000 13:31:25 GMT

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.