My Oracle Support Banner

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

Last updated on FEBRUARY 19, 2019

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

4. Submit




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.