Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Querying v$ tables very slow after upgrade

Re: Querying v$ tables very slow after upgrade

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Mon, 25 Jun 2007 14:34:59 -0500
Message-ID: <ad3aa4c90706251234i332c606dpa242da60b363c74e@mail.gmail.com>


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
Received on Mon Jun 25 2007 - 14:34:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US