Home » RDBMS Server » Performance Tuning » How to do update statistics on oracle 10g database (10g)
How to do update statistics on oracle 10g database [message #309484] Thu, 27 March 2008 12:44 Go to next message
brandond
Messages: 20
Registered: March 2008
Junior Member
I'm needing to update stats on all tables in the database, and an unsure how to do so, and haven't been able to find any documentation for it. Could someone help me in this, either point me to the documentation, or show me the code on how to make this happen.

Thanks
Re: How to do update statistics on oracle 10g database [message #309490 is a reply to message #309484] Thu, 27 March 2008 12:50 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use dbms_stats but Oracle does it automatically in 10g.

Regards
Michel
Re: How to do update statistics on oracle 10g database [message #309492 is a reply to message #309484] Thu, 27 March 2008 12:55 Go to previous messageGo to next message
brandond
Messages: 20
Registered: March 2008
Junior Member
how often does 10g do the update stats?

thanks for your help

Re: How to do update statistics on oracle 10g database [message #309495 is a reply to message #309492] Thu, 27 March 2008 12:58 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't have a 10g database now but if you have one just check the scheduled jobs one is relative to statistics computation.

Regards
Michel
Previous Topic: CAN ANY ONE PROVIDE ME THE STATSPACK SCRIPTS
Next Topic: Query takes long time to execute first time
Goto Forum:
  


Current Time: Mon Dec 05 21:28:06 CST 2016

Total time taken to generate the page: 0.17897 seconds