Performance Issue With PS13 Upgrade Scripts Execution (Doc ID 2154067.1)

Last updated on JULY 19, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.5.0.0.0 to 7.5.0.13.0 [Release 7.5.0]
Information in this document applies to any platform.

Symptoms

Scenario:

While testing PS13 installation on a test environment with production data, the time achieved are extremely high.

During a test installation, install.sh script ran for 18 hours for a first secondary schema before is was aborted. According to V$SESSION_LONGOPS view on the database it would continue to run for at least additional 36 hours. And that is for a single secondary schema, of which we have 4.
Additionally, the pin_75_75MPS1_upgrade.pl script runs for about 48 hours per secondary schema.

The times are enormous. Could you please provide a way to shorten them?

Cause

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