Question

2
Replies
176
Views
MODIS Member since 2012 2 posts
PEGA
Posted: August 24, 2016
Last activity: November 8, 2016
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***

Low-Code App Development Installation and Deployment
Moderation Team has archived post
Share this page LinkedIn