Question

8
Replies
5064
Views
Anurathan_K Member since 2016 17 posts
ANZ Bank
Posted: February 20, 2017
Last activity: June 15, 2017
Closed
Solved

Seeking Advise on cache tables truncation in order to avoid performance issues

We are advised to truncate the following cache tables to avoid performance issues. Please advise me that how often we can do this cache tables truncation? Can we do this while Pega is online? Do we have to restart after truncation by deleting the PegaRULES_Extract_Marker.txt file? Is this following list is enough or do we have to consider any different cache table(s) for Pega 7.1.9? Would it be feasible to have an Agent activity to truncate these tables by weekly without system restart?

TRUNCATE TABLE PR_SYS_APP_HIERARCHY_FLAT;

TRUNCATE TABLE PR_SYS_APP_RULESET_INDEX;

TRUNCATE TABLE PR_SYS_CLASS_ANCESTORS;

TRUNCATE TABLE PR_ASSEMBLEDCLASSES;

TRUNCATE TABLE PR4_RULE_SYSGEN;

TRUNCATE TABLE PR_SYS_APPCACHE_ENTRY;

TRUNCATE TABLE PR_SYS_APPCACHE_DEP;

TRUNCATE TABLE PR_SYS_APPCACHE_SHORTCUT;

TRUNCATE TABLE PR_SYS_CACHE_DEP;

TRUNCATE TABLE PR_SYS_CACHE_ENTRY;

TRUNCATE TABLE PR_SYS_CACHE_IMPL;

TRUNCATE TABLE PR_SYS_CACHE_DEP;

***Updated by moderator: Lochan to branch reply into a new post***

Original Post: What cache tables should be truncated?

Data Integration System Administration
Moderation Team has archived post
Share this page LinkedIn