Re: Why do I get out of memory errors when 10GB memory is free?
From: John Hurley <johnbhurley_at_sbcglobal.net>
Date: Sat, 4 Jul 2009 14:19:42 -0700 (PDT)
Message-ID: <2392f163-dc0d-486a-a8ac-0a91bf240912_at_l31g2000yqb.googlegroups.com>
On Jul 4, 6:39 am, zigzagdna <zigzag..._at_yahoo.com> wrote:
Date: Sat, 4 Jul 2009 14:19:42 -0700 (PDT)
Message-ID: <2392f163-dc0d-486a-a8ac-0a91bf240912_at_l31g2000yqb.googlegroups.com>
On Jul 4, 6:39 am, zigzagdna <zigzag..._at_yahoo.com> wrote:
snip
> I am on HP UNIX 64bit 11.23 titanium using oracle 10.2.0.3. My server
> has 24GB memory and of that 10GB is free (as seen in glance). When I
> doing oracle exp or rman commands, I get:
> ORA-04030: out of process memory when trying to allocate 1049112 bytes
> (KSFQ heap,KSFQ Buffers)
> I checked both rman and exp are 64bit executables, so they should be
> able to access all the memory on the system.
Have you looked at the documentation from oracle on how to set the hpux kernel parameters ( correctly)?
It is going to take some aggressive settings to allow oracle to allocate and use effectively that much memory. Received on Sat Jul 04 2009 - 16:19:42 CDT