Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 febry lim (febry lim)
asuransi sinarmas
IT Manager
asuransi sinarmas
ID
febry lim Member since 2015 30 posts
asuransi sinarmas
Posted: Jun 26, 2018
Last activity: Jun 26, 2018
Posted: 26 Jun 2018 6:50 EDT
Last activity: 26 Jun 2018 7:22 EDT
Closed

DML list for pr_sys_locks etc

Hi According to this Article :

https://community.pega.com/knowledgebase/articles/performance-guidance-production-applications-database

we need to defrag and do proper tuning to :

  • pr_sys_locks
  • pr_sys_updatescache
  • pr_sys_context
  • pr_page_store
  • pc_data_unique_id

after discussing with our dba, we need an list of DML performed on all of those table.

where can i get this list ?

To see attachments, please log in.
Data Integration

Posted: 6 years ago
Posted: 26 Jun 2018 7:22 EDT
Ujjwal Kumar Shukla (UjjwalShukla_GCS)
PEGA
Senior Manager, Technical Support
Pegasystems Inc.
IN

Hi There,

There could be several DMLs depending on the operation, hence it would be good to choose the DML that are frequently executed at your end.

To get the list please monitor Pega Alerts logs for Pega0005 alerts.
It would contain all the query that are performing badly.

Regards,
Ujjwal 

To see attachments, please log in.

Related content:

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice