Memory Target Advisory missing in 11gr2 AWR
Hey Guys, We are running databases with AMM using the memory_target setting. All other pools have the default setting - no mimimum value set.
Questions
1. What memory advisories should I be heeding to? Memory target, SGA target OR buffer cache advisories? I see the memory target advisory, dba_hist/gv$memory_target_advice views, is not reporting any benefit with doubling the memory target as such. Looking into the AWR (instance report), buffer cache advisory is suggesting an improved 'estimated physical read factor' - of 30%. Which one should I be going with? The specific pool advisory OR the AMM memory_target advisory? I suspect it is the memory target advisory.
0