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: poor performance after migration from 7.2.2 to 7.3.4.0.1

Re: poor performance after migration from 7.2.2 to 7.3.4.0.1

From: <tedchyn_at_yahoo.com>
Date: Thu, 20 May 1999 01:00:12 GMT
Message-ID: <7hvmqr$v01$1@nnrp1.deja.com>


sigrid, did you update stat after migration ? do explain or sqltrace to find out what happen to your queries.

Ted
In article <7hsicb$h13$1_at_ernie.haupt.de>,   Sigrid Staudte <sstaudte_at_sachsenlb.de> 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
>

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Wed May 19 1999 - 20:00:12 CDT

Original text of this message

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