4 Replies Latest reply: Dec 11, 2012 9:11 AM by Srini Chavali-Oracle RSS

    Effect of changing optimizer_features_enable='11.2.0.3' after 11203 upgrade

    971614
      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.