Re: Table stats in 10.2

"sybrandb" <sybrandb@xxxxxxxxx> wrote in message
news:1146230344.941742.66450@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
10g collects statistics automagically. You'll don't need monitoring
anymore, monitoring is the default.
Likely the job is being submitted through dbms_scheduler.
The New Features Manual (or the New Features course in which this is
addressed) is your friend

--
Sybrand Bakker
Senior Oracle DBA


The only points to add to that are that
the scheduler kicks the job off every 24 hours
tables with stale (or no) stats are analyzed
the sample size is AUTO
the choice of columns needing histograms is AUTO
the number of buckets for each histogram is set to AUTO


--
Regards

Jonathan Lewis
http://www.oracle.com/technology/community/oracle_ace/ace1.html#lewis

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html



.

Relevant Pages