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: 8i to 9i migration, performance issues

Re: 8i to 9i migration, performance issues

From: paddy_nyr <mpprpp_at_yahoo.com>
Date: Thu, 11 Mar 2004 11:19:18 -0500
Message-ID: <c2q3ip$20ibdb$1@ID-197123.news.uni-berlin.de>

"rohit" <rohitk1973_at_yahoo.com> wrote in message news:74353ecc.0403110805.4e42475e_at_posting.google.com...
> this ones a lollypop for most...
> we migrated 8i to 9i, 9.2.0.3.0. All the objects were moved, the
> server configuration remains identical. After this migration a lot of
> reports and pl/sql are taking a lot longer than they were before, and
> the execution plan is not abnormal in any way. What's missing......
> RK
>

Did you recalulate your statistics on your schemas? Received on Thu Mar 11 2004 - 10:19:18 CST

Original text of this message

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