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***