RE: Querying v$ tables very slow after upgrade

  • From: <Joel.Patterson@xxxxxxxxxxx>
  • To: <oracledba.williams@xxxxxxxxx>, <Patty.Charlebois@xxxxxxxxxxxxxx>
  • Date: Mon, 25 Jun 2007 15:27:20 -0400

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

 

Other related posts: