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.

Symptoms

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

Cause

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