Re: Gather statistics in Oracle 10g and higher database
- From: Carlos Sierra <carlos.sierra.usa@xxxxxxxxx>
- To: hemantkchitale@xxxxxxxxx
- Date: Tue, 25 Sep 2012 05:49:36 -0400
If you have been using dbms_stats with default parameters on 9i, be aware
those same parameters have very different defaults as you move to 10g or
11g. In particular be aware of estimate_percent and method_opt.
On Fri, Sep 21, 2012 at 4:56 AM, Hemant K Chitale
<hemantkchitale@xxxxxxxxx>wrote:
> By a job that is scheduled in DBA_SCHEDULER_JOBS in 10g and
> DBA_AUTOTASK_TASKS in 11g
> Hemant KChitale
>
> On Fri, Sep 21, 2012 at 11:35 AM, Mandal, Ashoke <
> ashoke.k.mandal@xxxxxxxxxxxxx> wrote:
>
> >
> > Could anyone describe how the statistics is generated in Oracle 10g
> > database automatically?
> >
> > Thanks,
> > Ashoke Mandal.
> >
> >
> >
> Hemant K Chitale
> http://hemantoracledba.blogspot.com
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Cheers -- Carlos Sierra
http://carlos-sierra.net/
--
//www.freelists.org/webpage/oracle-l
Other related posts:
