During An Upgrade From CCB 2.3.1 (SP10) To CCB 184.108.40.206 The Degree Of Parallelism (DOP) Is Changed
Last updated on SEPTEMBER 19, 2017
Applies to:Oracle Utilities Customer Care and Billing - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
During an upgrade from CCB 2.3.1 (SP10) to CCB 18.104.22.168, as per the document CCB_DBA_Guide_v2_5_0_1.pdf 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 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?
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