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

Increasing SORT area will not help,You should consider decreasing the sort area size and
increase the SWAP. 4030 is a private memory error and reducing the SGA or increasing the
swap will solve the problem.

Best Regards,
K Gopalakrishnan
Bangalore, INDIA

"Ara Kassabian" <a_kassabian_at_hotmail.com> wrote in message news:1bc58618.0205201909.143e76ca_at_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:
>
> 1. Is there any intrinsic or default limit on session PGA at 250MB?
>
> 2. 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).
>
> 3. 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).
>
> 4. Could increasing sort_area_size help (even though shared and large
> pools are being under-utilized)?
>
> Thanks for your help.
>
> Ara
Received on Wed May 22 2002 - 06:35:47 CDT