My Oracle Support Banner

Performance Issue When Launching Upgrade Scripts from 7.0 to 7.3 (Doc ID 1582697.1)

Last updated on APRIL 16, 2019

Applies to:

Oracle Communications Billing and Revenue Management - Version to [Release 7.3.0]
Oracle Solaris on SPARC (32-bit)


When upgrading from BRM version 7.0 to version 7.5 PS4, and during execution of the upgrade script from BRM 7.0 to BRM 7.3, performance issue caused upgrade bottleneck.

When kicked off the upgrade scripts, initially for 7.0 to 7.3 which contains the account product split feature. It was running at a very slow pace, only 12% has been completed for three days.

According to the user's DBA, it was running the following snippet of the upgrade script:

Investigation shown the part that was trying to update the PACKAGE_ID after the ACCOUNT_PRODUCTS_T table has been renamed to the PURCHASED_PRODUCT_T table.  




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

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