Re: Oracle PGA sizing and ORA-4030

From: gazzag <gareth_at_jamms.org>
Date: Thu, 26 Nov 2009 03:03:26 -0800 (PST)
Message-ID: <fb8b9168-b33e-44ab-827a-98fc80c34de3_at_g27g2000yqn.googlegroups.com>



On 26 Nov, 08:54, Joerg Rueschenschmidt <jrueschenschm..._at_t-online.de> wrote:
> Hello all,
>
> okay, if PGA can grow above pga_aggregate_target we can indeed hit the 2
> GByte OS limit which causes ORA-4030 finally.
>
> Thanks ...
>
> Joerg- Hide

That's the O/S limitation, unfortunately. I know. I'm stuck using Windows too.

-g Received on Thu Nov 26 2009 - 05:03:26 CST

Original text of this message