Managing table growth
In production settings, some tables are likely to grow to contain 100,00 or more rows. It is useful to monitor these tables to know when to adjust the amount of tablespace.
The tables are:
pr4_perf_usage
– Supports system usage reportingpr_log
– Other logspc_history_work
– Used for work item historypr_history_data
– Used for data object historypc_index_workparty
– Used for work party identifierspc_data_workattach
– Used for attachments to work itemspc_link_attachment
– Used for attachments to work itemspr_data
– Used for work item parties, outgoing emailpc_work
or similar tables, which store work items.
The following tables typically show stable or slowly growing row counts:
pr4_rule_*
– Rulespc_assign_*
– Assignments (notpr_assign
)pr_sys_*
– System tablespr4_base
– Foundation rulespr4_history_rule
– Rule change history
Previous topic More about Declare Index rules Next topic Trimming and purging tables