Symptom
Following single SQL with SQL_ID=33r9rd5127u5h takes long time and it causes entire Unicode conversion slow.
SQL STATEMENT:
SELECT /*+ FIRST_ROWS (1) */ T_02."WARPL",MAX(T_02."ABNUM") FROM "MPLA" T_00 INNER JOIN "MPOS" T_01 ON T_01."MANDT"=:A0 AND T_00."WARPL"=T_01."WARPL" INNER JOIN "MHIO" T_02 ON T_02."MANDT"=:A1 AND T_01."WARPL"=T_02."WARPL" AND T_01."WAPOS"=T_02."WPPOS" INNER JOIN "MHIS" T_03 ON T_03."MANDT"=:A2 AND T_02."WARPL"=T_03."WARPL" AND T_02."ABNUM"=T_03."ABNUM" WHERE T_00."MANDT"=:A3 AND (T_00."MPTYP"=:A4 OR T_00."MPTYP"=:A5) AND T_01."EQUNR"=:A6 AND T_02."ABNUM"<>:A7 AND T_03."TSVBT"=:A8 GROUP BY T_02."WARPL"
Read more...
Environment
ECC 6.0 EHP4
Netweaver 7.01
Oracle 19c
Product
Keywords
Unicode conversion slow, 33r9rd5127u5h, MHIS , KBA , BC-DB-ORA , Oracle , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview