Re: Dbms_stats Analyze Data Dictionay ?

"Daniel Morgan" <damorgan_at_exxesolutions.com> wrote in message news:3ECFDC3E.DB2E454C_at_exxesolutions.com...
> Ryan wrote:
>
> > never, ever, ever analyze the data dictionary. that is in the system
> > tablespaces. this is why dbms_utility's version of analyze is not used.
> >
> > data dictionary uses the RBO. in version 10 its going to use the CBO. no
> > word on whether we will gather stats on it then.
> > "Ste" <schen_at_prodigy.net> wrote in message
> > news:9_Pza.9$Dj1.7_at_newssvr19.news.prodigy.com...
> > > Hi,
> > >
> > > Have anyone analyze data dictionary (sys tables) using dbms_stats?
How
> > > often do you run it and do you use whole database stats or schema for
sys?
> > > Please share with your experience.
> > >
> > > TIA,
> > >
> > > St
> > >
> > >
>
> Actually in 9i it appears to be acceptable (see thread on this from
earlier this
> year) but in 8i and before anyone running statistics on SYS objects doomed
their
> database to running at a snail's pace.
>
> --
> Daniel Morgan
> http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
> damorgan_at_x.washington.edu
> (replace 'x' with a 'u' to reply)
>
>

acceptable? does it help at all or its just not a bad thing? Received on Sat May 24 2003 - 19:56:02 CDT