Re: 8i to 9i migration, performance issues

From: rjp <rjp.l_at_laposte.net>
Date: 12 Mar 2004 00:57:23 -0800
Message-ID: <9b7a7215.0403120057.3199bf13@posting.google.com>

Hi,

Yes, this problem occurs frequently.
- One way is to add the parameter optimizer_feature_enable=817 to force the CBO to work like the 8i way.
- You should use 'DBMS_STAT' instead 'analyze schema' or 'DBMS_UTILITY.ANALYZE_SCHEMA' rjp

rohitk1973_at_yahoo.com (rohit) 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
Received on Fri Mar 12 2004 - 02:57:23 CST