RE: Querying v$ tables very slow after upgrade

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  

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