Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

optimizer_features_enable set to 10.2.0.4 on Oracle 11.2.0.4

user2551998Sep 9 2015 — edited Sep 10 2015

Have a client asking for confirmation that running Oracle 11.2.0.4 with optimizer_features_enable set to 10.2.0.4 is fully supported so support matrix to check is for Oracle 11.2.0.4 and not for Oracle 10.2.0.4.

This is to enable them to move to new database version with old application prior to upgrading application and enabling Oracle 11.2.0.4 optimizer features.

Any one able to confirm?

Thanks

Comments

top.gun

The matrix always refers to the version, and not system parameters like optimizer_features_enable.

Hemant K Chitale

Not exactly everything in the optimizer will work as in 10.2.0.4   Some changes in the optimizer that are bug fixes may not revert behaviour to 10.2  So, you should still test the application.

The Upgrade documentation allows you to set O_F_E to 10.2.x.x even when running 11.2.x.x

Hemant K Chitale

BPeaslandDBA 


This is to enable them to move to new database version with old application prior to upgrading application and enabling Oracle 11.2.0.4 optimizer features.

That's pretty much the intent of this parameter. But in my experience, this parameter is not a magic bullet. Test your application thoroughly. I've seen it where setting this parm to the older version doesn't always do as I expected.

Cheers,
Brian

1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 8 2015
Added on Sep 9 2015
#database-upgrade
3 comments
818 views