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
sumang24
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: 64153
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.

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


Current Time: Sun Dec 11 00:35:26 CST 2016

Total time taken to generate the page: 0.15090 seconds