Clarity

  • Private Community

  • 1.  Oracle Optimizer Settings

    Posted Nov 04, 2015 04:12 PM

    Do you know if we still recommend that clients use the optimizer_features_enable settings of “9.2.0“  for Oracle 11g?

     

    Thanks in advance!



  • 2.  Re: Oracle Optimizer Settings

    Posted Nov 04, 2015 04:49 PM

    Stephen,

    Running Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64 bit Production provides me using select * from v$parameter where name like 'optimizer%' yields the following:

     

    optimizer_features_enable     value = 11.2.0.3

    optimizer_mode                      value = ALL_ROWS

     

    Hope this helps you out.



  • 3.  Re: Oracle Optimizer Settings

    Posted Nov 04, 2015 05:04 PM

    Current guidance is to leave the optimizer setting to the out of the box value for the Oracle database and version.



  • 4.  Re: Oracle Optimizer Settings

    Posted Nov 04, 2015 05:18 PM

    CLRT-21633 ERQ: Support native optimizers in Oracle 10g and later

     

    As of Clarity 12.0 this has been implemented, the following note (which was applicable back then) was also mentioned:

    This is only applicable to Oracle version 10.2.0.4 and above. Earlier versions suffer from Oracle bug 4752814 with Parameterized Queries.