This content has been marked as final. Show 1 reply
i've found on metalink this article: ID 1443482.1 in witch they say:
The causes for TX deadlock in S mode wait can be:
a. ITL contention, eg: INITRANS setting for the object is too small, it can not handle the number of concurrent transactions.
The solution is to increase INITRANS setting for the object involved in the deadlock using "alter table" or "alter index" command
b. If the object invovled is an unique key index, the wait could be cauesd by uniqueness validation. Application need to be checked to aovid unique key violation.