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!

recommended optimizer_mode settings in oracle database 12c

DDebAug 20 2015 — edited Aug 21 2015

Hello Experts,

I am planning to upgarde oracle database from 10.2.0.5 to 12.1.0.2 and I have a doubt regarding optimizer_mode parameter setting.I know from 12c rule based optimization is no longer supported so my question is what is the impact of keeping optimizer_mode as CHOOSE and what is the recommended value? Any document reference will be very helpful to convince my senior management.

Regards

Dhritinan Deb

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 18 2015

Added on Aug 20 2015

#database-upgrade

2 comments

761 views