My Oracle Support Banner

Performance issue with respect to Order Movement related SQL (Doc ID 1552043.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Transportation Management - Version 6.2.5 and later
Information in this document applies to any platform.

Symptoms



Monitoring of daily AWR report has identified a SQL Statement generated from application which gets held up while execution and take a considerable database resource.

SELECT UNIQUE omd.order_movement_gid, ssd.shipment_gid, om.source_tag, om.dest_tag, om.source_location_gid, om.dest_location_gid, ssul.s_ship_unit_gid, ssu.ship_unit_gid, ssu.range_start, ssu.range_end, ssd.stop_num, ssd.activity, ssul.or_line_gid FROM order_movement om, order_movement_d omd,s_ship_unit_line ssul, shipment_stop_d ssd, s_ship_unit ssu WHERE om.perspective = :1 AND ssul.s_ship_unit_gid = omd.s_ship_unit_gid AND ssu.s_ship_unit_gid = ssul.s_ship_unit_gid AND om.order_movement_gid = omd.order_movement_gid AND ssu.s_ship_unit_gid = ssd.s_ship_unit_gid AND ssd.shipment_gid = om.shipment_gid AND ssu.s_ship_unit_gid IN (:2,:3)



Cause

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
Symptoms
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.