I believe you are correct. No statistics on sys tables on 8i or 9i, but put them on sys tables in 10g. On 6/25/07, Joel.Patterson@xxxxxxxxxxx <Joel.Patterson@xxxxxxxxxxx> wrote:
I cannot speak for the list, but I believe that 10g does have statistics on SYS tables. Let others verify that – cause I don't wish to double check now Joel Patterson Database Administrator joel.patterson@xxxxxxxxxxx x72546 904 727-2546 ------------------------------ *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto: oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Dennis Williams *Sent:* Monday, June 25, 2007 2:12 PM *To:* Patty.Charlebois@xxxxxxxxxxxxxx *Cc:* Oracle-L@xxxxxxxxxxxxx *Subject:* Re: Querying v$ tables very slow after upgrade Patty, I haven't experienced 10g yet, but the advice I recall on this list was not to have statistics on SYS tables. Can anyone else on the list clarify that? Dennis Williams
-- Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.'