Translation of "Chapter 6. Locks and deadlocks." of "Methods for searching errors in SQL application" just published.
By Sveta Smirnova-Oracle on Jul 07, 2010
This is new part which contains information about what to do if problem is repeatable only when queries run concurrently.
Chapter 6. Locks and deadlocks.
In the last part we discussed how to find cause of the problem in case
if it is always repeatable. But there are cases when problem occurs
only under particular circumstances.
For example, such easy query can run long enough: