We have an SAP ECC system running on Oracle 19 with 4 TB DB in Cloud environment.
Users has reported performance issue on some of the FI Tcodes where it is getting Time Out issues.
Present DIA time out set for 1800 seconds.
We did some analysis and found that there is an issue in sequential read of tables and indexes and it’s taking too much time more then expected. We also discussed the same with SAP and as per our environment and hardware configuration, SAP suggest to change some Oracle Cache Parameters to improve the same.
Tweaking Oracle cache parameters somehow increase the performance but FAGLL03 tcode is still giving issue as this tcode is reading the data from multiple tables (cluster tables) while doing the Inner Joins in Explain Plan and giving Time out dump. We think to create an index on the table but before creating index we search for any standard SAP note which explain this issue, however there are plenty of SAP notes and blogs which explain this kind of issue but none of it useful as we are using all the same conditions and parameters which already suggested in blogs. Later SAP suggested Note “1524829” to implement the same in landscape(based on release compatibility) to resolve this issue.
Please Note – This note is only applicable for Oracle DB and it’s not available to download for everyone until any SAP engineer suggest.
I hope may be this note will help to resolve this common issue.