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.