Long Running DELETE (GTM_TR_PROD_CLASSIFICATION) During 6.3.3 Upgrade (Doc ID 1916507.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Transportation Management - Version 6.3.3 to 6.3.5 [Release 6.3]
Information in this document applies to any platform.

Symptoms

During the OTM Upgrade to 6.3.3, the dbpatch_63.sql takes hours to run

Creating new tables...
Compiling 631 packages....
No errors.
No errors.
Applying preupdates...
Applying preupdates...
Compiling 632 packages....
Applying preupdates...
Applying preupdates...
Compiling 633 packages....
Applying preupdates....
Applying preupdates...
create sequence

Then the following DELETE executes and consumes (99%) one-full-CPU. The DELETE Executes for 9 Hours. (and none is deleted)

DELETE FROM GTM_TR_PROD_CLASSIFICATION GTA
WHERE ROWID < ANY (
SELECT ROWID FROM GTM_TR_PROD_CLASSIFICATION GTB
WHERE GTA.GTM_TRANSACTION_LINE_GID =
GTB.GTM_TRANSACTION_LINE_GID
AND GTA.GTM_PRODUCT_CLASS_TYPE_GID =
GTB.GTM_PRODUCT_CLASS_TYPE_GID
AND GTA.GTM_PROD_CLASS_CODE_GID =
GTB.GTM_PROD_CLASS_CODE_GID)

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