Re: Oracle PGA sizing and ORA-4030

From: Carlos <miotromailcarlos_at_netscape.net>
Date: Wed, 25 Nov 2009 00:23:10 -0800 (PST)
Message-ID: <a3078f64-4ba0-41d5-b0aa-2e49467d82d6_at_l2g2000yqd.googlegroups.com>

On Nov 25, 8:56 am, Joerg Rueschescmidt <jrueschenschm..._at_t-online.de> wrote:
> 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

'Target' is a target, not a limit. It seems you are hitting the (hidden) parameter 'pga_max_size'.

HTH. Cheers.

Carlos. Received on Wed Nov 25 2009 - 02:23:10 CST