Table Grow even though CZ Purge Program is Executed Regularly

(Doc ID 365354.1)

Last updated on DECEMBER 14, 2017

Applies to:

Oracle Configurator - Version 11.5.9 to 11.5.10.2 [Release 11.5 to 11.5.10]
Information in this document applies to any platform.

Goal

Why are the following tables are growing very rapidly in production System?
TABLE_NAME NUM_ROWS
------------------------------ ----------
CZ_CONFIG_ATTRIBUTES 682640
CZ_CONFIG_EXT_ATTRIBUTES 49468440
CZ_CONFIG_HDRS 1035840
CZ_CONFIG_INPUTS 20749060
CZ_CONFIG_ITEMS 88237550
CZ_DB_LOGS 11315160
CZ_EXPRESSIONS 29620
CZ_EXPRESSION_NODES 87200
CZ_LOCALIZED_TEXTS 95800
CZ_PS_NODES 53890
CZ_PS_PROP_VALS 19675

TABLE_NAME NUM_ROWS
------------------------------ ----------
CZ_TERMINATE_MSGS 28060
CZ_UI_NODES 35920
CZ_UI_NODE_PROPS 68590

to purge above tables we used standard purge programs and it purged very few records.

Are there any purging scripts for CZ to purge valid records?




Solution

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