System Performance Poor Following Upgrade to Oracle 19c

[taketake]

When we upgraded our SAP ERP system from Oracle 11g to 19c, the performance of the abap program went down significantly.

Detailed system information before and after the upgrade is provided below.

Has anyone else experienced the same problem?

If so, how was it resolved?

[Before]

　　SAP：SAP ERP 6.0 EHP5
　　SAPkernel：SAP KERNEL 7.21 EXT 64-BIT UC
　　Oracle：Oracle 11g（11.2.0.3）
　　OS：Windows Server 2008 R2

[After]

　　SAP：SAP ERP 6.0 EHP5
　　SAPkernel：SAP KERNEL 7.22 EX2 64-BIT UC
　　Oracle：Oracle 19c（19.1.0）

　　OS：Windows Server 2019

[mamartins]

Please review SAP notes 2799900, 2800001, and 1020260.

Install latest ORACLE patches, and consider reorganize the tables and recalculate the statistics.

Also review this ORACLE document: Performance problems after upgrade? Use STATSPACK… (FAQ - Complete Reference DOC ID 94224.1)

[JamesZ]

To analyze the issue:

A complete upgrade means, SBP and parameter are adpated for 19c. => I suppose this is done.

So please share:

1, in st03n, it shows database slow or sap abap slow?
2. if it is database slow, what wait event is high?
3. or can you share awr report?
4. if there is particular sql(s) slow, then please share, we can try to tune

Or you can book a TPPO service from SAP sales/tqm to do some performance tuning.

[taketake]

Mr. James Zhang

Thank you very much for your reply.

>1, in st03n, it shows database slow or sap abap slow?

SAP abap slow.

>3. or can you share awr report?

The performance of the DB itself is not bad,

so we are puzzled as to why the performance degradation of the ABAP program is occurring.

[JamesZ]

If it is abap processing slow, you may reach SAP support.
Sorry I am only working oracle side, have no idea on abap. -(