RE: quick statistics question

From: Kenneth Naim <kennethnaim_at_gmail.com>
Date: Wed, 17 Dec 2014 23:17:51 -0500
Message-ID: <064201d01a79$97d184c0$c7748e40$_at_gmail.com>

What version of 11g are you on? 11.2.0.1, 11.2.0.2 etc.  

Ken  

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Maureen English Sent: Wednesday, December 17, 2014 10:25 AM To: oracle-l_at_freelists.org
Subject: quick statistics question  

We just migrated our reporting instance from 10g to 11g and I planned to let Oracle do all the

statistics gathering using the automatic jobs. Unfortunately, I also imported the statistics from the old database as part of the migration and now I have queries that are consistently hanging.

I think I need a sanity check. Does it make sense to delete the statistics on the tables

involved in these queries, and then gather them with the basic gather table stats statement?

Since these are all materialized views that get refreshed (either complete or fast) just about every night, I was hoping that Oracle would just decide that statistics needed to be generated on them after they were refreshed.

• Maureen

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

Received on Thu Dec 18 2014 - 05:17:51 CET