During the Upgrade From 11i to 12.1 / 12.2, Cost Management Scripts cstmtaupg.sql and cstwtaupg.sql Hang or Show Performance Issues Running Slow (Doc ID 2138514.1)

Last updated on MAY 18, 2016

Applies to:

Oracle Applications DBA - Version 11.5.10.2 to 12.2 [Release 11.5.10 to 12.2Cloud]
Oracle Cost Management - Version 11.5.10.2 to 12.2 [Release 11.5 to 12.2]
Information in this document applies to any platform.

Goal

During the upgrade from 11i to 12.1 or 12.2, Cost Management scripts cstmtaupg.sql and cstwtaupg.sql take a long time to process (9 hours and 7 hours respectively).


Discuss steps to decrease the script run time, and reduce downtime for the upgrade.
 

Solution

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