Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: gather_schema_stats
Thanks for the warning. I've already backed up my stats so I can always go
back to the ones I know work well if I need to.
-- Chuck "Telemachus" <telemachus_at_ulysseswillreturn.net> wrote in message news:%%qa9.11476$zX3.19137_at_news.indigo.ie...Received on Thu Aug 29 2002 - 14:55:19 CDT
> No. The Gather OPTION is only useful if doing table monitoring.
> Use Cascade=true.
>
>
> Gather_schema_stats is perilous due to the unexpected changes that can
> occur in plan changes .... i.e. it's a big stick.
>
> Is this an attempt to do set peoplesoft_go_faster=true ?
> "Chuck" <chuckh_at_softhome.net> wrote in message
> news:akdcrk$1h5oo8$1_at_ID-85580.news.dfncis.de...
> > Does dbms_stats.gather_schema_stats gather index stats by default or
not?
> > The documentation on the CASCADE parameter seems to indicate that it
does
> > not, but the documentation on the OPTION parameter seems to indicate
that
> it
> > does. First it says that CASCADE must be set to true (default is false)
to
> > do indexes. But the default for OPTION is "GATHER" which means to gather
> > stats on *all* schema objects and the last time I checked, indexes were
> > considered objects. If I run the following, will it or will it not
gather
> > index stats?
> >
> > BEGIN
> > DBMS_STATS.GATHER_SCHEMA_STATS(
> > ownname => 'PSOFT',
> > estimate_percent => 25);
> > END;
> >
> >
>
>