Poor Performance Due to a Missing Index on the OB_SU_RELEASE_INSTRUCTIONS.OB_SU_RELEASE_INSTR_GID
Last updated on JULY 09, 2014
Applies to:Oracle Transportation Management - Version: 5.0
This problem can occur on any platform.
-- Problem Statement:
Orders sent in via integration are taking longer than expected to process. OMD threads, in the EventDiagServlet, show a processing time of up to 10 minutes and explain plans on standard queries, inserts and updates on the OB_SU_RELEASE_INSTRUCTION table using OB_SU_RELEASE_INSTR_GID as a qualifier show a full table scan is being done.
-- Steps To Reproduce:
No specific steps were provided to reproduce this issue.
-- Business Impact:
Sending in large batches of orders bases and creating order releases via integration can take several minutes per order. This reduces overall throughput of the system.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms