Re: Oracle PGA sizing and ORA-4030
Date: Thu, 26 Nov 2009 04:18:21 +0000 (UTC)
On Wed, 25 Nov 2009 08:56:03 +0100, Joerg Rueschescmidt wrote:
> 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 ...
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.Received on Wed Nov 25 2009 - 22:18:21 CST