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='' after 11203 upgrade

971614 Newbie
Currently Being Moderated

I upgraded oracle applications 11i ( instance's database from * to*.

After upgrade I found below parameter as,

and i want to change it as below,

What is the effect of changing optimizer_features_enable to '' 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,


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