Question

8
Replies
5244
Views
Anurathan Kalithasappulavar (Anurathan_K)
ANZ Bank
SSA
ANZ Bank
AU
Anurathan_K Member since 2016 17 posts
ANZ Bank
Posted: February 20, 2017
Last activity: June 15, 2017
Posted: 20 Feb 2017 20:14 EST
Last activity: 15 Jun 2017 0:37 EDT
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, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.