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 JULY 20, 2024

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

	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

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