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
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.

Re: Stale Statisics [message #336896 is a reply to message #336877] Tue, 29 July 2008 05:24 Go to previous message
Michel Cadot
Messages: 63907
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Just posted this less than 2 hours ago:

It seems you didn't search before posting.

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

Current Time: Thu Oct 20 19:41:00 CDT 2016

Total time taken to generate the page: 0.11788 seconds