Optimizer Merge Patch

[Former Member]

I'm looking at "SAP Note 1165319 - Optimizer merge fix for Oracle 10.2.0.4".

Does the merge patch 8775584 contain all the following previous merge patches, especially merge patch 7228971 which contains the work around "_fix_control"='6329318:OFF'?

8775584: OPTIMIZER MERGE LABEL REQUEST ON TOP OF 10.2.0.4 FOR SAP (#15) <<<< This is the only merge patch we applied.

8526100: OPTIMIZER MERGE LABEL REQUEST ON TOP OF 10.2.0.4 FOR SAP (#13)

8467800: OPTIMIZER MERGE LABEL REQUEST ON TOP OF 10.2.0.4 FOR SAP (#12)

8299095: OPTIMIZER MERGE LABEL REQUEST ON TOP OF 10.2.0.4 FOR SAP (#11)

8201796: OPTIMIZER MERGE LABEL REQUEST ON TOP OF 10.2.0.4 FOR SAP (#10)

7664560: OPTIMIZER MERGE LABEL REQUEST ON TOP OF 10.2.0.4 FOR SAP (#9)

7592168: OPTIMIZER MERGE LABEL REQUEST ON TOP OF 10.2.0.4 FOR SAP (#8)

7522608: OPTIMIZER MERGE LABEL REQUEST ON TOP OF 10.2.0.4 FOR SAP (#7)

7454131: OPTIMIZER MERGE LABEL REQUEST ON TOP OF 10.2.0.4 FOR SAP (#6)

7366749: OPTIMIZER MERGE LABEL REQUEST ON TOP OF 10.2.0.4 FOR SAP (#5)

7331569: OPTIMIZER MERGE LABEL REQUEST ON TOP OF 10.2.0.4 FOR SAP (#4)

7228971: OPTIMIZER MERGE LABEL REQUEST ON TOP OF 10.2.0.4 FOR SAP (#3) <<<< This is the fix we need

7149751: OPTIMIZER MERGE LABEL REQUEST ON TOP OF 10.2.0.4 FOR SAP (#2)

6988848: OPTIMIZER MERGE LABEL REQUEST ON TOP OF 10.2.0.4 FOR SAP (#1)

I am using Oracle 10.2.0.4. on AIX 6.1

Thanks in advance.

[lbreddemann · Accepted solution]

> Does the merge patch 8775584 contain all the following previous merge patches, especially merge patch 7228971 which contains the work around "_fix_control"='6329318:OFF'?

Yes, the Optimizer Merge Fixes should always contain all previously released merge fix patches.

regards,

Lars

[Former Member · Accepted solution]

after you have applied the latest optimizer merge fix, check the opatch output for your DB.. There you will find the list of bugs fixes applied with the latest merger fix. You will surely get the bug number 7228971 listed there as applied!

regards,

Anup