CZ Tables Have Large Number Of Records, cz_prop_vals table slow (Doc ID 1494520.1)

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.

Symptoms

On : 12.1.1 version, Maintenance

ACTUAL BEHAVIOR
---------------
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.


STEPS
-----------------------
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

4. Submit

Cause

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