Solution : https://service.sap.com/sap/support/notes/413427 (SAP Service marketplace login required)
Summary :
When configuring SAP systems with Oracle databases (8044, 805*, 8.0.6), performance degradation and SQL terminations may be observed primarily when accessing V_IBIN_SYVAL, IBINOBS in LIBINFF4V, and IBINOWN in LIBINFF3W or LIBINFF95 via Transaction SM50. This issue often stems from incorrect database settings or outdated indexes. To resolve, refresh the database indexes via Transaction DB20 for the affected views and tables. Additionally, ensure database configurations adhere to guidelines provided in SAP Note 170989.
Key words :
considerable performance problems occur, long times occur, ibsymbol files ibin, accessing view v_ibin_syval, ibinobs files ibin, v_ibin_syval ibin, accessing ibinobs, affected files, accessing ibinown, edit configurations
Related Notes :
| 170989 | Poor performance under Oracle 8044, 805*, 8.0.6 |