Re: CBO for sys/system objects

Sybrand Bakker wrote:
>
> On 5 Apr 2006 09:06:48 -0700, wagen123_at_yahoo.com wrote:
>
> >Oracle9i 9207 (64 bit)
> >Solaris 9 (64 bit)
> >
> >We generate statistics for the user schemas via dbms_stats. Works fine
> >although we had to tune a few queries with the RULE hint since it was
> >faster.
> >
> >Questions:
> >1) should we generate statistics for the sys/system objects? Is it
> >recommended in 9i? we use the default stats gathering in 10g which
> >includes the sys/system objects (out of the box)
> >2) any known issues in 9i?
> >
> >Thanks for any pointers.
> >wagen
>
> Not supported in 9i.
>
> --
> Sybrand Bakker, Senior Oracle DBA

*supported* in 9.2, and recommended if optimizer_dynamic_sampling is 2 or more at the instance level

hth
Connor

-- 
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
Co-author: "Oracle Insight - Tales of the OakTable"

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com


"Semper in excremento, sole profundum qui variat."

------------------------------------------------------------