Re: CBO for sys/system objects

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