Oracle MWA Is Slow "Please Wait" While Using Load and Drop
Last updated on JANUARY 16, 2018
Applies to:Oracle Warehouse Management - Version 12.1.3 and later
Information in this document applies to any platform.
On : 12.1.3 version, Performance
Oracle MWA is slow "Please Wait" --- but only a few times/week. It cannot be reproduced at will
Using the Mobile Device the users are finding "Please Wait...." for a long time. It was tracked from a backend session and found that this query was running and taking long time:
SELECT DISTINCT QT.TASK_ID TASK_NUM, QT.PICK_SLIP, WDT.TASK_TYPE WMS_TASK_TYPE_ID, NVL(WDT.PRIORITY, 0) TASK_PRIORITY, DECODE(:B15 , 2, MOL.HEADER_ID, NULL) BATCH_ID, SUB.PICKING_ORDER SUB_PICKING_ORDER, LOC.PICKING_ORDER LOC_PICKING_ORDER, ((NVL(LOC.X_COORDINATE, 0) - :B14 ) *(NVL(LOC.X_COORDINATE, 0) - :B14 ) + (NVL(LOC.Y_COORDINATE, 0) - :B13 ) *(NVL(LOC.Y_COORDINATE, 0) - :B13 ) + (NVL(LOC.Z_COORDINATE, 0) - :B12 ) *(NVL(LOC.Z_COORDINATE, 0) - :B12 )) DISTANCE, WDT.STATUS TASK_STATUS, QT.TRANSACTION_TYPE_ID, QT.TRANSACTION_ACTION_ID, QT.TRANSACTION_SOURCE_ID, QT.TRANSACTION_SOURCE_TYPE_ID FROM WMS_DISPATCHED_TASKS WDT, (SELECT TRANSACTION_TEMP_ID TASK_ID, PICK_SLIP_NUMBER PICK_SLIP, CARTONIZATION_ID, ORGANIZATION_ID, SUBINVENTORY_CODE, LOCATOR_ID, MOVE_ORDER_LINE_ID, TRANSACTION_TYPE_ID, TRANSACTION_ACTION_ID, TRANSACTION_SOURCE_ID, TRANSACTION_SOURCE_TYPE_ID FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT WHERE WMS_TASK_TYPE IS NOT NULL AND TRANSACTION_TEMP_ID = DECODE(:B7 , 'BULK', PARE
The database session for this was in the wait event "gc cr request" frequently even though there were no issues in the RAC cluster.
Expect to have better performance
The issue cannot be reproduced at will -- but it was happening during Pick Load and Drop
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms