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: 65146
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: Reverse key index
Next Topic: Report hangs
Goto Forum:

Current Time: Mon Aug 21 07:12:55 CDT 2017

Total time taken to generate the page: 0.04399 seconds