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 ---------- --------------- ------------------- 1116 .5 1.0030 1604 .75 1.0010 2252 1 1 2820 1.25 .9999 3306 1.5 .9999 3886 1.75 .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 ---------- ---------- -------------------- 110 66 22917 250 66 22112 300 95 0 800 96 0 1100 96 0 1340 96 0 1580 96 0 1800 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 -- //www.freelists.org/webpage/oracle-l