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

Home -> Community -> Usenet -> c.d.o.server -> Re: Imported DB runs SLOWER on faster machine

Re: Imported DB runs SLOWER on faster machine

From: Rick Denoire <100.17706_at_germanynet.de>
Date: Tue, 23 Jul 2002 23:47:07 +0200
Message-ID: <cmgrjuko698vidlmu3p7i5grvt46ru1a0v@4ax.com>


Daniel Morgan <dmorgan_at_exesolutions.com> wrote:

>I could add a lot of additional items to your list of two. All of which
>have to do with tuning. But the most glaring thing missing from your
>posting is that you didn't run DBMS_STATS to analyze tables and indexes.
>So, if that is the case, the CBO is just making wild guesses or out on
>vacation
>
>Daniel Morgan

Oh please go ahead! Give me some keywords. Gathering statistics is a good point to start with.

You won't believe me how concerned I am about maintaining the production DB, but I forgot such elementary things in the Test DB!

Thanks
Rick Received on Tue Jul 23 2002 - 16:47:07 CDT

Original text of this message

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