Re: 8i to 9i migration, performance issues

RK,

Here's a plan:

1. Identify the queries that *MUST* work.
2. Switch the optimizer temporarily back to 8i with optimizer_features_enable.
3. Create a stored outline for these queries.
4. Switch the optimizer back to 9i.

As long as the stored outline exists, you'll still get your 8i access plan. This will give you a little breathing room to go fix the problem without having to lose all of the cool new features of 9i. Plus, you'll have invested a little bit of time in learning how to setup plan stability in case you want to use it again in the future.

Mark Simmons
Sr. Oracle DBA
Sabre-Holdings, Southlake, TX

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 - 17:58:48 CST