Re: Oracle PGA sizing and ORA-4030

From: Joerg Rueschenschmidt <jrueschenschmidt_at_t-online.de>
Date: Thu, 26 Nov 2009 09:54:51 +0100
Message-ID: <helfos$e0g$01$1_at_news.t-online.com>

Joerg Rueschescmidt schrieb:
> Hello,
>
> we use Oracle 10.2.0.4 on Windows 32 Bit platform and run sometimes into
> ORA-4030 problems.
>
> Current memory settings are :
>
> sga_max_size : 1504M
> sga_target : 1304M
> pga_aggregate_target : 400 M
>
> According this configuration I should not hit the 2 Gbyte limit on 32
> bit platforms.
>
> However, if I look to statistics "maximum PGA allocated" it seems PGA
> can grow above 400M. I think this causes my random ORA-4030 problems.
>
> My questions is
>
> How is it possible memory allocated to PGA can grow above
> pga_aggregate_target value?
>
> Regards ...
>
> Joerg

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 Received on Thu Nov 26 2009 - 02:54:51 CST