Re: Gather statistics in Oracle 10g and higher database
From: Carlos Sierra <carlos.sierra.usa_at_gmail.com>
Date: Tue, 25 Sep 2012 05:49:36 -0400
Message-ID: <CAGzKQQcBUChVr32_LqbRmieC6pNrsiD77+-b++48M-zMx_FPNg_at_mail.gmail.com>
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_at_gmail.com>wrote:
Date: Tue, 25 Sep 2012 05:49:36 -0400
Message-ID: <CAGzKQQcBUChVr32_LqbRmieC6pNrsiD77+-b++48M-zMx_FPNg_at_mail.gmail.com>
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_at_gmail.com>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_at_medtronic.com> wrote:
>
> >
> > Could anyone describe how the statistics is generated in Oracle 10g
> > database automatically?
> >
> > Thanks,
> > Ashoke Mandal.
> >
> >
> >
> Hemant K Chitale
> http://hemantoracledba.blogspot.com
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- Cheers -- Carlos Sierra http://carlos-sierra.net/ -- http://www.freelists.org/webpage/oracle-lReceived on Tue Sep 25 2012 - 04:49:36 CDT