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

 Sudhir Modi (MODIS)
PEGA
Contractor
Pegasystems Inc.
US
MODIS Member since 2012 2 posts
PEGA
Posted: Aug 24, 2016
Last activity: Nov 8, 2016
Posted: 24 Aug 2016 13:42 EDT
Last activity: 8 Nov 2016 11:36 EST
Closed
Solved

What should we set Transaction Commit Level (isolation level)  ?

Our DBA noticed that update pr_sys_locks   query is taking 450 sec. thats unusual. during reserch we found that we have isolation level set to default. If we change isolation level to "2" (only read commited records) would help? 

 

***Updated by Moderator: Vidyaranjan. Removed user added  Ask the Expert tag. Apologies for confusion, shouldn't have been an end-user option***

***Updated by Moderator: Marissa to update categories***

To see attachments, please log in.
Installation and Deployment

Accepted Solution

Posted: 8 years ago
Posted: 5 Sep 2016 22:13 EDT
Lochana Durgada Vijayakumar (Lochan_DV)
PEGA
Senior Manager, Knowledge Management
Pegasystems Inc.
IN

Hello,

The user replied via a private message that the issue has been resolved by setting the isolation level to 2.

Regards,
Lochan  |  Community Moderator  |  Pegasystems Inc.

To see attachments, please log in.

Accepted Solution

Posted: 8 years ago
Posted: 5 Sep 2016 22:13 EDT
Lochana Durgada Vijayakumar (Lochan_DV)
PEGA
Senior Manager, Knowledge Management
Pegasystems Inc.
IN

Hello,

The user replied via a private message that the issue has been resolved by setting the isolation level to 2.

Regards,
Lochan  |  Community Moderator  |  Pegasystems Inc.

To see attachments, please log in.

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