Re: Poor Performance ORACLE 8.0.5

From: Jerry Gitomer <jgitomer_at_hbsrx.com>
Date: Mon, 14 Jun 1999 09:21:20 -0400
Message-ID: <7k3377$t5g$2@autumn.news.rcn.net>

Hi,

When dealing with a product as complex as Oracle there could be many reasons for the slowdown. The first two I would check are:

Did you run ANALYZE COMPUTE or ANALYZE ESTIMATE on your tables since you migrated? The Cost Based Optimizer needs the statistics generated by ANALYZE to come up with efficient execution plans.

Also look for differences in initialization parameters, especially in the sizes of the areas in the SGA. The Oracle defaults are (to be generous) on the small side and should be increased substantially.

regards

Jerry Gitomer

Wolle wrote in message <7jrpi1$oep$1_at_news.online.de>...
>After migration from ORACLE 7.3.2 to 8.0.5 (OS: HP UX 10.20) we have a very
>poor performance when executing PL/SQL packages. With ORACLE 7.3.2 the
>execution of PL/SQL was up to 40 % faster. Within the PL/SQL packages we
are
>using often PL/SQL-tables (index-by-tables).
>
>Can anyone help me ?
>
>
>
>
Received on Mon Jun 14 1999 - 08:21:20 CDT