My Oracle Support Banner

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

Last updated on OCTOBER 17, 2013

Applies to:

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

Symptoms

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.  

Cause

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
Symptoms
Cause
Solution
References


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