Table Grow even though CZ Purge Program is Executed Regularly
(Doc ID 365354.1)
Last updated on APRIL 04, 2022
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
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
| Goal |
| Solution |
| References |