I have a third party application. My users have started using it full fledged recently and since then I have this great job of killing sessions because they seem to get locked!
The statement in question is a delete statement which says
delete table x where
or something of that sort, as in there is a where clause which specifies what rows to delete. My problem is that no two users will be accessing the same set of rows and still they get locked. What could be the problem and what is the solution?