Re: Analyze gather statistics automated in 10g?

I found the following article by Mladen Gogala helpful:

http://www.dba-oracle.com/t_gather_stats_job.htm

If you are using OEM, if is failry simple to see your maintenance windows
and see whether the default timing works for your specific application.
In one of my apps, I have most of the tables analyzed automatically, while
others are analyzed after they are loaded.


Gene Gurevich




                                                                       
             "J. Dex"                                                
             <cemail_219@hotma                                         
             il.com>                                                    To
             Sent by:                  <oracle-l@xxxxxxxxxxxxx>      
             oracle-l-bounce@f                                          cc
             reelists.org                                            
                                                                   Subject
                                       Analyze gather statistics automated
             03/30/2009 03:33          in 10g?                         
             PM                                                        
                                                                       
                                                                       
             Please respond to                                         
             cemail_219@hotmai                                         
                   l.com                                             
                                                                       
                                                                       




After having read some documentation, I am still confused.  Is the process
of running analyze gathering statistics automated in 10g (specifically
10.2.0.3) or is there still something that needs to be set up to get it to
regularly run?   What needs to be set up?  How do you set it up?

In the past, we have had a cron job that runs weekly that does the
following:
exec dbms_stats.gather_database_stats(estimate_percent=>20,cascade=>true);

How is everybody else handling this?

I know that running reports is automated and you don't need to set up
perfstat, etc., but my question relates to the actual analyze process.




Express your personality in color! Preview and select themes for Hotmail®.
See how.


Please consider the environment before printing this email.


--
http://www.freelists.org/webpage/oracle-l

Other related posts: