Oracle Parameter _FIX_CONTROL: EWA vs SAP Note Recommendation?

[#1]

We have Oracle 11.2.0.2 on RedHat Linux

cat /$ORACLE_HOME/sapbundle/version.txt

SAP Bundle Patch 11.2.0.2.3 - 201108

For FIXCONTROL '6055658:OFF' what recommendation should I take the SAP Note or EWA?

1) SAP NOTE

In the SAP Note 1431798 "Oracle 11_2_0 Database Parameter Settings" ...

May 12, 2011:

added FIXCONTROL '6055658:OFF' for UNIX

FIXCONTROL

'6055658:OFF' UNIX SBP 11201x_date ( date >= 201105 )

So the SAP Note looks like FIXCONTROL should contain '6055658:OFF'

2) EWA

Settings defined but not recommended

6055658:OFF

Thanks in advance.

[Former Member · Accepted solution]

Hello Bill,

You should always check and go with the recommendation from the parameter note.

10g - 830576

11g -1431798

For the fixcontrol parameters, these were introduced to allow enabling and disabling of optimizer fixes . The corresponding patch therefore needs to be installed to enable you to you set the required parameter. With EWA, this report usually flags any parameter which may require further checking, (ie because a note exists that details behaviour of setting this parameter for example a performance behaviour in OLTP versus OLAP). EWA is doing this to ensure that the DBA is aware that there is some additional step, info regarding the parameter. The Colleagues above have already mentioned to run the parameter script which checks it's result against the Oracle version parameter note and flags any incorrect setting and also provides the setting that is recommended. Before you do this you should check the relevant parameter note for these recommendations.

Hope this helps

Best Regards

Rachel

Edited by: Rachel Holloway on Mar 4, 2012 2:18 PM

[Former Member]

Hi Bill,

For FIXCONTROL '6055658:OFF' what recommendation should I take the SAP Note or EWA?

Please use SAP Note 1171650 - Automated Oracle DB parameter check

Download the script parameter_check_112.txt and run in SQL Editor in ST04.

The automated parameter check provide consistent and up to date recommendations from SAP rather than EWA.

For OLAP systems like BW, SCM etc., you need to replace the string '<OLAP System? [n]>' with 'y' in the attached SQL script.

Br,

Venky

[Former Member]

Hi Bill,

Accordingly to the SAP note 1431798, the FIXCONTROL for '6055658:OFF' should be set if you have installed the SBP date >= 201105. In your case, this setting need to be set.

You can use the script that attached in the SAP note 1171650 to double check the Oracle parameters.

Thanks,

Ivy