Home » RDBMS Server » Performance Tuning » v$sga_target_advice view
v$sga_target_advice view [message #259216] Tue, 14 August 2007 12:17 Go to next message
Messages: 10
Registered: July 2005
Junior Member
Has anyone on this forum used the recommendations from this view? I am seeing contant recommendations to increase the sga by 75% . How credible is the info given by this view?

Thank You
Re: v$sga_target_advice view [message #259218 is a reply to message #259216] Tue, 14 August 2007 12:37 Go to previous message
Michel Cadot
Messages: 63929
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In this case I tend to use StatsPack or AWR... to see if the reason may be some applications don't use bind variables or something like this before applying the recommendation.

Previous Topic: Update Statement - Performance Tuning
Next Topic: very high redo space wait ratios on 10g
Goto Forum:

Current Time: Wed Oct 26 18:27:57 CDT 2016

Total time taken to generate the page: 0.08631 seconds