Re: DBA view slow

From: Thomas Kyte <thomas.kyte_at_oracle.com>
Date: 14 Oct 2004 16:05:06 -0700
Message-ID: <7b0834a8.0410141505.466ddaa3@posting.google.com>

Bricklen <bricklen_at_zyahoo.zcomz> wrote in message news:<Sqzbd.10247$z96.3272_at_clgrps12>...
> Turkbear wrote:
> > According to , in addition to others, Thomas Kyte( who I consider one of, if not the, best sources for Oracle info), the SYS
> > and SYSTEM schemas (especially SYS) should not be analyzed because the recursive Sql Oracle generated over the years was
> > highly optimized for the RULE-based optimizer..Having statistics on a SYS-owned table will cause your database to operate
> > slower than it should.
> > (paraphrased from "Expert one-on-one Oracle" By Thomas Kyte..Published by Wrox)
> >
> >
> IIRC isn't this for <= 8i, though? I thought that in 9i it was sometimes
> done (but only on recommendation from Support?), and in 10g it is the
> default?
>
> disclaimer, I've never seen any sys/system schemas analyzed.

correct -- in 9i - as long as you tested it, in test, before "just doing it" on your production machine, stats on sys are ok

and in 10g, they are there. Received on Thu Oct 14 2004 - 18:05:06 CDT