Oracle PGA sizing and ORA-4030
From: Joerg Rueschescmidt <jrueschenschmidt_at_t-online.de>
Date: Wed, 25 Nov 2009 08:56:03 +0100
Message-ID: <heinuo$us5$03$1_at_news.t-online.com>
Hello,
Date: Wed, 25 Nov 2009 08:56:03 +0100
Message-ID: <heinuo$us5$03$1_at_news.t-online.com>
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 Received on Wed Nov 25 2009 - 01:56:03 CST