OPTIMIZER_FEATURES_ENABLE = 8.1.7 to 9.2.0

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

Baran

note 124361 does not contain any entry for parameter OPTIMIZER_FEATURES_ENABLE

[Former Member · Accepted solution]

In case your system is not a BW:

Have a look at SAP note 124361.

Don't set parameters not mentioned in this note, as explicitely stated there.

This means: Don't set OPTIMIZER_FEATURES_ENABLE.

hope this helps

Sorry, mixed up SAP notes myself, trying to correct.

Edited several times; should be ok now.

Edited by: Joe Bo. on Dec 23, 2008 10:15 AM

[Former Member · Accepted solution]

Hi Joe,

Does according to the note we should not set parameter OPTIMIZER_FEATURES_ENABLE when database is running on 9.2.0.7

Kindly confirm ???

[Former Member · Accepted solution]

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