CZ Tables Have Large Number Of Records, cz_prop_vals table slow
Last updated on JULY 20, 2017
Applies to:Oracle Configurator - Version 12.1.1 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.
On : 12.1.1 version, Maintenance
Running CZ PURGE on the EBS PROD target instance where there are close to 500 million records in CZ_PS_PROP_VALS and
another 200 million records in other tables is now the crucial next step in getting our data cleaned.
When CZ PURGE was ran in an EBS CODE FREEZE environment (similar to EBS PROD), it had about 400 million total records,
it took approximately 3 weeks to complete because it would timeout after x number of hours and had to be restarted.
The one table CZ_PS_PROP_VALS alone will take many days or a week or more to complete.
The issue can be reproduced at will with the following steps:
1. Log in to Oracle Configurator Administrator responsibility
2. Go to Schedule
3. Select 'Purge Configurator Tables' concurrent process
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