Re: Migration from 8i to 11g
From: Dennis Williams <oracledba.williams_at_gmail.com>
Date: Wed, 7 Mar 2012 12:33:14 -0600
Message-ID: <CAGRGHjyH6ysEuK=f9MSc2-qO9wyUTbwZcca7s4xXRpKyajn9hA_at_mail.gmail.com>
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.
Date: Wed, 7 Mar 2012 12:33:14 -0600
Message-ID: <CAGRGHjyH6ysEuK=f9MSc2-qO9wyUTbwZcca7s4xXRpKyajn9hA_at_mail.gmail.com>
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-lReceived on Wed Mar 07 2012 - 12:33:14 CST