Re: Querying v$ tables very slow after upgrade

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_at_crowley.com <Joel.Patterson_at_crowley.com> 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_at_crowley.com
> x72546
> 904 727-2546
> ------------------------------
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Dennis Williams
> *Sent:* Monday, June 25, 2007 2:12 PM
> *To:* Patty.Charlebois_at_greenshield.ca
> *Cc:* Oracle-L_at_freelists.org
> *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.'

--
http://www.freelists.org/webpage/oracle-l