there was a note on the oracle-l list quite recently to the effect that the
9.2 documentation includes a note stating that collection of stats is now
supported, and someone pointed out that the data dictionary seemed to be
acquiring a bunch of HINTS, which would seem to support this patchset note.
However I cannot find said note by searching the docs, as I also can't find
a note saying you shouldn't do it, this probably suggests that the fault is
with my queries.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Vladimir M. Zakharychev" <bob_at_dpsp-yes.com> wrote in message
news:b4n6jn$lua$1_at_babylon.agtel.net...
> "Never collect statistics on SYS" - well, with RBO not being there in v10
> this rule certainly will be invalid. But it seems that 9.2 already
invalidates
> it (at least partially). An excerpt from 9.2.0.3 patch set release notes:
>
> During upgrade from 9201->9202/9203 running catpatch.sql
> can take a long time if there are stats for the SYS schema.
> The user should delete the statistics on all the objects in the SYS
> schema, and then re-collect the statistics after normal database open
> if necessary.
> To me, this means that you can have stats on SYS without negative
> impact on performance in 9.2. Not that you *should* have them, but
> you *can* and this won't hurt. Any expert care to comment?
>
> --
> Vladimir Zakharychev (bob_at_dpsp-yes.com)
http://www.dpsp-yes.com
> Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet
applications.
> All opinions are mine and do not necessarily go in line with those of my
employer.
>
>
>
Received on Wed Mar 12 2003 - 07:50:39 CST
