Re: Migration from 8i to 11g

From: Rodd Holman <rodd.holman@xxxxxxxxx>
To: "'oracle-l@xxxxxxxxxxxxx' (oracle-l@xxxxxxxxxxxxx)" <oracle-l@xxxxxxxxxxxxx>
Date: Wed, 7 Mar 2012 12:55:10 -0600

I second this.  We migrated from 9i to 10g in 2007.  Oracle had
significantly changed/re-written the CBO.  Things that used to fly,
crawled.  There is definitely a post migration need to stress test your
queries, and user adhoc queries if they are allowed.
Rodd Holman

On Wed, Mar 7, 2012 at 12:33 PM, Dennis Williams <
oracledba.williams@xxxxxxxxx> wrote:

> David, (resending without quoting prior posts)
> Does your applications on 8i use RBO or CBO? Even if it uses CBO, the query
> execution plans may differ in 11g. When we migrated some critical apps from
> 8i to 10g a few years ago (a direct upgrade) that was the main source of
> issues.
>
> Dennis Williams
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Follow-Ups:

RE: Migration from 8i to 11g
From: Walker, Jed S

References:
- Migration from 8i to 11g
  - From: David Ramírez Reyes
- Re: Migration from 8i to 11g
  - From: kathryn axelrod
- Re: Migration from 8i to 11g
  - From: kathryn axelrod
- RE: Migration from 8i to 11g
  - From: Walker, Jed S
- Re: Migration from 8i to 11g
  - From: Dennis Williams

Re: Migration from 8i to 11g

Other related posts: