Database Administration (MOSC)

MOSC Banner

Memory Target Advisory missing in 11gr2 AWR

edited Oct 2, 2012 4:25AM in Database Administration (MOSC) 4 commentsAnswered
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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center