Performance Issue When Launching Upgrade Scripts from 7.0 To 7.3
Last updated on OCTOBER 17, 2013
Applies to:Oracle Communications Billing and Revenue Management - Version 220.127.116.11.0 to 18.104.22.168.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 was faced and cause 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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms