Skip to Content
author's profile photo Former Member
Former Member

OPTIMIZER_FEATURES_ENABLE = 8.1.7 to 9.2.0

Dear support,

While running CheckDB we were getting warning in system as

BR0978W Database profile alert - level: WARNING, parameter: OPTIMIZER_FEATURES_ENABLE, value: 8.1.7 (<> 9.2.0)

our database is running at version 9.2.0.7

In order to avoid this warning we have done changes in INITSID.ora and changed

parameter OPTIMIZER_FEATURES_ENABLE = 9.2.0 from 8.1.7

but after restart we faced major performance issue in the system and there are other 2 parameters

automatically got changed because of this change as mentioned below.

OPTIMIZER_DYNAMIC_SAMPLING got changed automatically from 0 to 1

OPTIMIZER_MAX_PERMUTATIONS got changed automatically from 80000 to 2000

Now we have reverted settings back to previous i.e OPTIMIZER_FEATURES_ENABLE = 8.1.7

Due to which other 2 parameters also changed back to original vlues 0 and 80000 automatically.

Kindly suggess what should be the correct value for this parameter OPTIMIZER_FEATURES_ENABLE if our database version

is 8.1.7

Best Regards,

RR

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 23, 2008 at 08:22 AM

    Hello,

    set please this parameter according to following notes:

    for BW Systems + 9.2 Oracle Database:

    Note 632556 - Oracle 9.2.0. database parameterization for BW*

    For non BW Systems + 9.2 Oracle Database

    Note 124361 - Oracle parameterization (R/3 >= 4.x, Oracle 8.x/9.x)

    Best regards

    Baran

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Yes,

      note 124361 clearly says so.

      Do not set any parameters that are not mentioned in this note.

      Exceptions could be possible, but first try without.

      (Presuming your system is not a BW,

      and your SAP version is 4.0B or above. You didn't tell us.

      But nowadays almost all SAP systems are.)

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.