Oracle PGA sizing and ORA-4030

From: Joerg Rueschescmidt <>
Date: Wed, 25 Nov 2009 08:56:03 +0100
Message-ID: <heinuo$us5$03$>


we use Oracle 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 Received on Wed Nov 25 2009 - 01:56:03 CST

Original text of this message