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: 7 years ago
Posted: 26 Jun 2018 7:22 EDT
Ujjwal Kumar Shukla (UjjwalShukla_GCS)
PEGA
Senior Manager, Technical Support, Stability and Reliability
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:

Question

purpose PXEXPIREDATETIME in PR_SYS_LOCKS

Question

Blocking on pr_sys_locks and pr_sys_locks_sla tables

Question

Defragmentation of pr_sys_locks while importing Application Jar

Question Solved

How to resolve Pega0005 alert due to pr_sys_locks

Question Solved

Lock cache, lock not present in pr_sys_locks while  performing  assignment (Pega v7.2)

Question

Wrong date getting insert into pr_sys_locks table on the pxExpireDateTime value

Question

OLD entries not getting removed from PR_SYS_LOCK post the pxexpiredatetime is reached

Question

How to resolve PEGA0005 alert due to pr_sys_locks insert query

Question Solved

Is it best practice to create database index for pr_sys_locks?

Question

INITRANS value(to allow multiple concurrent sessions to update the same data blocks ) for the Pega OOTB WORK and PR_SYS_LOCKS tables (current value 1 in our application)

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