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

Report message to a moderator

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: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Feb 08 16:48:36 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.