RE: Querying v$ tables very slow after upgrade

  • From: "Randy Johnson" <randyjo@xxxxxxxxxxxxx>
  • To: <Patty.Charlebois@xxxxxxxxxxxxxx>, <Oracle-L@xxxxxxxxxxxxx>
  • Date: Mon, 25 Jun 2007 18:49:45 -0500

You might want to check to make sure that there are NOT stats on the
sys.uet$ and sys.fet$ tables. These tables should not have stats even in
10g. 


 

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Patty.Charlebois@xxxxxxxxxxxxxx
Sent: Monday, June 25, 2007 11:47 AM
To: Oracle-L@xxxxxxxxxxxxx
Subject: Querying v$ tables very slow after upgrade

After upgrading our production database from 9.2.0.7 to 10.2.0.3 yesterday
we are having severe performance problems when trying to query any dba_*
view or v$* view.

I checked and stats were gathered for all SYS tables during the upgrade, the
last_analyzed date is the time of the upgrade.

Does anyone have any experience with this?

Thanks,

Patty



This e-mail is confidential, intended solely for the use of the
recipient(s) to whom it was addressed. If you have received it in error,
please do not copy or distribute this e-mail. We ask that you notify us
immediately by replying to the sender and then delete this e-mail. E-mail
sent or received over the internet may not be secure. You should use caution
when sending e-mail messages containing private and confidential information
or consider other secure means to send the information. If you have any
questions regarding the authenticity or security of the e-mail you have
received please do not hesitate to contact us at 1-800-265-5615.


Ce message de courriel est confidentiel et s?adresse uniquement à la
personne indiquée.  Si vous l?avez reçu par erreur, veuillez ne pas copier
ni distribuer ce message de courriel.
Nous vous demandons de nous aviser immédiatement en répondant à
l?expéditeur, puis en supprimant ce message.  Les messages envoyés ou reçus
par courriel pourraient ne pas être sécurisés.
Vous devriez être prudent lorsque vous envoyez des messages de courriel
contenant des renseignements confidentiels et privés ou songer à prendre
d?autres moyens sécurisés pour envoyer les renseignements.  Si vous avez des
questions concernant l?authenticité ou la sécurité d?un courriel que vous
avez reçu, n?hésitez pas à communiquer avec nous au 1 800 265-5615.
--
//www.freelists.org/webpage/oracle-l


No virus found in this incoming message.
Checked by AVG Free Edition. 
Version: 7.5.476 / Virus Database: 269.9.7/868 - Release Date: 6/25/2007
12:20 PM
 

No virus found in this outgoing message.
Checked by AVG Free Edition. 
Version: 7.5.476 / Virus Database: 269.9.7/868 - Release Date: 6/25/2007
12:20 PM
 

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


Other related posts: