Home How to handle row lock contention at application level
Reply: 0

How to handle row lock contention at application level

user5374
1#
user5374 Published in September 20, 2018, 1:15 pm

I have 2 applications (Spring - Hibernate with Boot) using same oracle database (11g). Both apps hit a specific table consistently and there are huge number of hits on this table. we can see row lock contention exceptions in the DB logs and applications have to be restarted each time we get these or when it creates a deadlock like situation.

we are using JPA entitymanager for these applications. need help for this issue

share|improve this question
  • this issue occurs when there are constant inserts and updates to one table. – Nikhil Surve Feb 11 at 13:06
  • One of the 2 apps has 5 spring schedulers implemented which also hit the same table. sorry for adding the info in comments section. – Nikhil Surve Feb 11 at 13:13

1 Answer 1

active oldest votes
up vote 0 down vote accepted
You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.305943 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO