Performance Issue while Upgrading the DB to CCB 220.127.116.11 (Alter Table CI_PAY_TNDR)
Last updated on OCTOBER 18, 2016
Applies to:Oracle Utilities Customer Care and Billing - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
During the upgrade from CC&B 2.3 FW 2.2 (SP10/20) to CC&B 2.4 FW 4.2 (SP3), the CCB2401_BpSchema3.SQL is quite long when altering the table CI_PAY_TNDR.
Currently default Parallel is set to 16 in the CCB2401_BpSchema3.SQL.
Despite that, there is only 1 oracle session doing the ALTER TABLE, instead of 16:
ALTER TABLE CI_PAY_TNDR MODIFY CUST_ID CHAR (36) PARALLEL 16 NOLOGGING;
ALTER TABLE CI_PAY_TNDR MODIFY EXT_REFERENCE_ID CHAR (36) PARALLEL 16 NOLOGGING;
How can the parallel be activated on the ALTER TABLE CI_PAY_TNDR query?
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