Long Running DELETE (GTM_TR_PROD_CLASSIFICATION) During 6.3.3 Upgrade
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.
During the OTM Upgrade to 6.3.3, the dbpatch_63.sql takes hours to run
Creating new tables...
Compiling 631 packages....
Compiling 632 packages....
Compiling 633 packages....
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 =
AND GTA.GTM_PRODUCT_CLASS_TYPE_GID =
AND GTA.GTM_PROD_CLASS_CODE_GID =
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