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
Re: Stale Statisics [message #336896 is a reply to message #336877] Tue, 29 July 2008 05:24 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: gather stats
Next Topic: Performance
Goto Forum:
  


Current Time: Sat Dec 03 20:41:49 CST 2016

Total time taken to generate the page: 0.25949 seconds