Re: Table stats in 10.2

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 28 Apr 2006 14:41:27 +0100
Message-ID: <r8OdnQIrOLgYhs_ZnZ2dnUVZ8qudnZ2d@bt.com>

"sybrandb" <sybrandb_at_yahoo.com> wrote in message news:1146230344.941742.66450_at_y43g2000cwc.googlegroups.com...
> 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

Received on Fri Apr 28 2006 - 08:41:27 CDT