Impact of Oracle upgrade on custom code

[Former Member]

Hi,

We are planning for an upgrade from Oracle 10g to 11i, but before that, we are asked to provide an analysis if this upgrade will impact any bespoke code developed by the SAP team. Can you please guide me on how to find out this impact?

Thanks in Advance,

Regards,

BIJOY

[Former Member · Accepted solution]

Hi Bijoy,

If you didn't access to the Oracle by the customer ABAP programs directly (exec sql/endexec block), there will no any impact at the ABAP stack.

Best regards,

Orkun Gedik

[Former Member]

Hello All,

Thanks for your reply. I also got a confirmation from SAP that Oracle upgrade will not impact custom code changes.

Regards,

BIJOY

[paul_power]

Hello Bijoy,

Could you clarify if you mean custom abap code developments?

These would not be affected by updating the db version.

Only an SAP upgrade / sp upgrade would affect abap custom code and is taken care of by prompting if you want to keep your chages or revert back to sap standard.

regards,

Paul

[volker_borowski2]

Hi,

substantially there should be no change. In special cases there might still be little stuff.

We observed a tendency that the optimizer from Oracle 11 is more in favor to hash joins than sort-merge joins. This might do something to the performance in either good or bad way, depending on real data. Most likely you will not notice that at all.

Volker