CBO for sys/system objects

From: <wagen123_at_yahoo.com>
Date: 5 Apr 2006 09:06:48 -0700
Message-ID: <1144253208.065103.225290@v46g2000cwv.googlegroups.com>

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 Received on Wed Apr 05 2006 - 11:06:48 CDT