PR_ASSEMBLEDCLASSES, PR_SYS_CACHE_ENTRY tables are having huge data

Hello All,


These two tables are growing at a rapid rate in out environment.





We are using PRPC 6.2 SP2 and Card CPM 6.2SP4 with oracle 11g and websphere 7.

I read the liknk 



Can  some one tell me how What is the usage of these tables.




**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.


Keep up to date on this post and subscribe to comments

June 26, 2015 - 6:36am

Hi buddy ,


did you get any solution for this  or not ? if yes can you please elabrate to me also

and i want remove these tables in our application at QA environment ? what is the processor for this?


Thanks in Advance for your quick updates on this 1



Ravi K

June 26, 2015 - 7:00am


Mentioned tables are cache related tables. If you feel size of this table increasing rapidly, you can truncate these tables and restart the server and observe the scenario.

You can use below script to truncate the tables.

TRUNCATE TABLE pr_sys_appcache_dep

TRUNCATE TABLE pr_assembledclasses