HELP: ORA-04030 on RS/6000 (Oracle 8.1.7.0.0)

From: Ara Kassabian <a_kassabian_at_hotmail.com>
Date: 20 May 2002 20:09:17 -0700
Message-ID: <1bc58618.0205201909.143e76ca@posting.google.com>

I am getting ORA-04030 on an AIX 4.3.3 box (running Oracle 8.1.7.0.0) when session PGA gets to be about 250MB. I was able to reproduce this with two different test cases. The server has 2GB of RAM and ulimits are set to unlimited (at both the user and default levels; i.e., in /etc/security/limits). I monitored both the shared and large pools and they have plenty of space.

After trawling through Metalink, usegroups, etc., I still do not have a clear answer. I hope somebody here can help me by answering the following questions:

Is there any intrinsic or default limit on session PGA at 250MB?
On Solaris, there are kernel parameters on shared memory limits. Is there a similar parameter on AIX? (BTW, I cross-posted this question to the AIX newsgroup).
Anybody else experienced a similar problem and was that resolved by applying a patch? There seem to be a bunch of patches related to memory leaks but nothing directly applicable (or, at least, not obviously so).
Could increasing sort_area_size help (even though shared and large pools are being under-utilized)?

Thanks for your help.

Ara Received on Mon May 20 2002 - 22:09:17 CDT