Discussion

2
Replies
382
Views
NisargK9 Member since 2014 27 posts
Tata Consultancy Services
Posted: June 22, 2016
Last activity: June 23, 2016
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
Share this page LinkedIn