SGA and PGA Advice
From: Sanjay Mishra <smishra_97_at_yahoo.com>
Date: Fri, 18 May 2012 20:12:44 -0700 (PDT)
Message-ID: <1337397164.88291.YahooMailNeo_at_web161201.mail.bf1.yahoo.com>
Hi Experts
Looking for some advice on v$sga_target_advice. I am seeing the following data from one of my 11g R2 Database. Not using AMM
4456 2 .9999
2200 96 0
Is that shows thatPGA_AGGREGATE_TARGET of 300M is enought or has to go for 800. Is 800 is only good value inspite not much cache hit and if provide some reason.
Date: Fri, 18 May 2012 20:12:44 -0700 (PDT)
Message-ID: <1337397164.88291.YahooMailNeo_at_web161201.mail.bf1.yahoo.com>
Hi Experts
Looking for some advice on v$sga_target_advice. I am seeing the following data from one of my 11g R2 Database. Not using AMM
SGA_SIZE SGA_SIZE_FACTOR ESTD_DB_TIME_FACTOR
---------- --------------- -------------------3886 1.75 .9999
1116 .5 1.0030
1604 .75 1.0010
2252 1 1
2820 1.25 .9999
3306 1.5 .9999
4456 2 .9999
Now it shows that current setting of sga_target of 2820 can be reduce to 1116 as there is not big benefit from 1116 to 2820 as bot shows ESTD_DB_IME_FACTOR close to 1. Or if we have to go with 2820. The reason is that there is not high memory on the system
Similarly v$pga_target_advice
PGA_MB CACHE_HIT ESTD_OVERALLOC_COUNT
---------- ---------- --------------------1800 96 0
110 66 22917
250 66 22112
300 95 0
800 96 0
1100 96 0
1340 96 0
1580 96 0
2200 96 0
Is that shows thatPGA_AGGREGATE_TARGET of 300M is enought or has to go for 800. Is 800 is only good value inspite not much cache hit and if provide some reason.
TIA
Sanjay
-- http://www.freelists.org/webpage/oracle-lReceived on Fri May 18 2012 - 22:12:44 CDT