Pga is growing on 11.2.2.0
From: walid kaakati <walid_alkaakati_at_yahoo.com>
Date: Tue, 14 Apr 2015 13:12:39 +0000
Message-ID: <520167451.2911923.1429017158966.JavaMail.yahoo_at_mail.yahoo.com>
Hi List,
Date: Tue, 14 Apr 2015 13:12:39 +0000
Message-ID: <520167451.2911923.1429017158966.JavaMail.yahoo_at_mail.yahoo.com>
Hi List,
We are running Oracle 11g 11.2.0.2 on windows Server 2008,i have set memory_target to 24GB. After a few days i see the SGA =9088 MB and PGA=15488 MB, the PGA Cache Hit % is 76,31 , in the ADDM i see actual used memory for PGA is only 400 MB ! , beside this Memory Target Advisor shows that i need to increase PGA to 18586 MB to get PGA cache hit ratio 90 %, My question is this normal ??! how i limit the the size of PGA ? through the time the buffer cache is decreasing for more PGA allocations !
Best wishes
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Apr 14 2015 - 15:12:39 CEST