Re: Imported DB runs SLOWER on faster machine

From: Vladimir M. Zakharychev <bob_at_dpsp-yes.com>
Date: Tue, 23 Jul 2002 13:12:42 +0400
Message-ID: <ahj6oj$feo$1@babylon.agtel.net>

"Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message news:3D3C9301.93124C13_at_exesolutions.com...

> 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 is probably right - you don't have any statistics collected after import and thus you either get FTS or index access where inappropriate. Also, your db_block_buffers may be set too low resulting in excessive physical i/o.

--
Vladimir Zakharychev (bob@dpsp-yes.com)                http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.

Received on Tue Jul 23 2002 - 04:12:42 CDT