Discussion

2
Replies
388
Views
Nisarg Kothari (NisargK9)
Tata Consultancy Services

Tata Consultancy Services
IN
NisargK9 Member since 2014 27 posts
Tata Consultancy Services
Posted: June 22, 2016
Last activity: June 23, 2016
Posted: 22 Jun 2016 12:28 EDT
Last activity: 23 Jun 2016 9:11 EDT
Closed

Volatile Tables (System Maintenance)

The tables pr_sys_locks, pr_sys_updatescache, pr_sys_context, etc are small and volatile, and thus vulnerable to fragmentation. Defragment them regularly by re-writing the table and rebuilding the indexes. In addition it may be advisable to cache them in a separate database buffer pool. Share the following list with your DBA for tuning.

 

Can someone elaborate please 

Pega Academy
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 Discussion, please write a new Discussion.