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
>
>
Received on Sat May 24 2003 - 15:04:44 CDT
