This discussion is archived
4 Replies Latest reply: Dec 11, 2012 7:11 AM by Srini Chavali-Oracle RSS

Effect of changing optimizer_features_enable='11.2.0.3' after 11203 upgrade

971614 Newbie
Currently Being Moderated
Hi,

I upgraded oracle applications 11i (11.5.10.2) instance's database from *11.2.0.2 to 11.2.0.3*.

After upgrade I found below parameter as,
optimizer_features_enable='11.2.0.2'

and i want to change it as below,
optimizer_features_enable='11.2.0.3'.

What is the effect of changing optimizer_features_enable to '11.2.0.3' on 11g database and 11i application.

Can you please suggest me what should I keep the value to optimizer_features_enable to make database and applications have no performance issues.


Warm regards,
Kishore.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points