My Oracle Support Banner

Poor Performance Due to a Missing Index on the OB_SU_RELEASE_INSTRUCTIONS.OB_SU_RELEASE_INSTR_GID (Doc ID 560242.1)

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.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.