Re: poor performance after migration from 7.2.2 to 7.3.4.0.1

From: Vitaliy Mogilevskiy <vit100gain_at_earthlink.net>
Date: Tue, 18 May 1999 15:00:00 -0700
Message-ID: <3741E2E0.7AF0CAE5@earthlink.net>

How did you migrated the database:
Import/Export ?
Did you lose any indexes?
Are your database parameters the same (SGA, DB_BLOCK_BUFFERS)?

Try answering this Q's you'll probably find out the reason of performance degradation.

Vitaliy Mogilevskiy
DBA Script Library @ http://home.earthlink.net/~vit100gain/index.html

Sigrid Staudte wrote:

> Hi,
>
> after migration a database from version 7.2.2 to 7.3.4.0.1 the
> execution of views are very slow. A view which select data from
> several tables works fine. When I join this view with another view
> or table for instance with a customer number then the performance is
> very poor. I have changed the select statements in several ways without
> success.
>
> Can everybody help me ?
>
> Regards...Sigrid
Received on Tue May 18 1999 - 17:00:00 CDT