During An Upgrade From CCB 2.3.1 (SP10) To CCB 2.5.0.1 The Degree Of Parallelism (DOP) Is Changed
(Doc ID 2123769.1)
Last updated on MAY 31, 2024
Applies to:
Oracle Utilities Customer Care and Billing - Version 2.5.0.1.0 and laterInformation in this document applies to any platform.
Goal
During an upgrade from Customer Care and Billing v2.3.1 SP10 (CC&B) to CC&B 2.5.0.1, as per the Database Administration Guide for v.2.5.0.1.0, it is recommended to execute the scripts CCB2401_BpSchema2.sql and CCB2401_BpSchema3.sql to improve performances of the upgrade process.
These scripts change the degree of parallelism (DOP) of few indexes / tables to 16. However, after the completion of the upgrade process the DOP remains at 16. There is no script to revert it back to the default. Was it intended that DOP should remain at 16 for these few indexes/tables?
Solution
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
Goal |
Solution |
References |