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 18.104.22.168.0 to 22.214.171.124.0 [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