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 to [Release 7.5.0]
Information in this document applies to any platform.



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

During a test installation, 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 script runs for about 48 hours per secondary schema.

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


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