Re: ORA-04030: out of process memory when trying to allocate 123952 bytes(callheap,temporary memory)

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-04030: out of process memory when trying to allocate 123952 bytes(callheap,temporary memory)

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: Thu, 29 Aug 2002 12:48:41 +0200
Message-ID: <akku6n$fum$1@ctb-nnrp2.saix.net>

yarly wrote:

> We are running 32-bit Oracle 9.0.1.3 on Solaris 8
> Our server is SUN E15K and we have 8GB RAM.
> The database is supporting an Oracle Applications 11i
>
> ORA-04030: out of process memory when trying to allocate 123952 bytes
> (callheap,temporary memory)

FWIW, had a similar problem on HP-UX 11 running 8.1.6 last year. It looked to me like a dinkum Oracle bug after some intensive debugging. A similar SQL processing _more_ data than the problematic one (and ran more than a 1000x longer), worked.

As far as I can recall, I think we narrowed it down to a join method... Anyway, we had to make some major changes to the processing and db anyway, and upgraded to 8.1.7 and I have not seen the problem since. Touch wood.

Could be worth your while to check Metalink on this.

--
Billy

Received on Thu Aug 29 2002 - 05:48:41 CDT