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
I believe Oracle called it optional in 9i and, of course, should be
done in 10g. In 9i I found it helped sometimes, was neutral some times,
and hurt occasionally. In 8i and before it was never to be done unless
the point was to bring Oracle to its knees.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Wed Apr 05 2006 - 13:37:07 CDT
