Home » RDBMS Server » Performance Tuning » Stale Statisics (Oracle 10g,Rel 2 ,Linux AS4)
Stale Statisics [message #336877] Tue, 29 July 2008 04:58 Go to next message
rsreddy28
Messages: 295
Registered: May 2007
Senior Member
Hello All,

In Oracle 9i/10g , we have a parameter STATISTICS_LEVEL=TYPICAL,
it calculates the statistics of the Database if modified.

How do you fix stale statistics? How can I see what is stale? Is there any view to observe the stale statistics. Any assistance would be appreciated.

Regards,
Rajasekhar

Report message to a moderator

Re: Stale Statisics [message #336896 is a reply to message #336877] Tue, 29 July 2008 05:24 Go to previous message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Just posted this less than 2 hours ago:
http://www.orafaq.com/forum/m/336831/102589/?#msg_336831

It seems you didn't search before posting.

Regards
Michel

Report message to a moderator

Previous Topic: gather stats
Next Topic: Performance
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 22 22:37:14 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.