Long Running Migration from 6.2.x to 6.3.7 and 6.4.1 AWR Shows DELETE FROM STATUS_VALUE WHERE OBJECT_TYPE = 'OMR' Taking Longer Than Expected

(Doc ID 2310862.1)

Last updated on OCTOBER 19, 2017

Applies to:

Oracle Transportation Management - Version 6.2.7 to 6.4.2 [Release 6.2 to 6.4]
Information in this document applies to any platform.


When migrating from 6.2.x up to 6.3.7 the following SQL statement running very long in the DB when running migration scripts.

Note: The same problem may be found on clients migrating to version 6.4.1


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