Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Another rule turning into a myth...
"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@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 - 05:43:58 CST