Re: Oracle PGA sizing and ORA-4030
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Thu, 26 Nov 2009 04:18:21 +0000 (UTC)
Message-ID: <hekvid$6i1$1_at_news.eternal-september.org>
On Wed, 25 Nov 2009 08:56:03 +0100, Joerg Rueschescmidt wrote:
Date: Thu, 26 Nov 2009 04:18:21 +0000 (UTC)
Message-ID: <hekvid$6i1$1_at_news.eternal-september.org>
On Wed, 25 Nov 2009 08:56:03 +0100, Joerg Rueschescmidt 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
Limit for the PGA is the address space limit for the virtual address space. It's defined by the OS, not by the Oracle instance.
-- http://mgogala.byethost5.comReceived on Wed Nov 25 2009 - 22:18:21 CST