Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Dbms_stats Analyze Data Dictionay ?
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)Received on Sat May 24 2003 - 15:55:27 CDT