Re: puzzling deadlock

You'll have to look more closely at the application's code. It is impossible for two concurrent sessions to issue just one DML statement and cause a deadlock. There have to be other DML statements involved. So you'll have to look at all the DML statements to figure out what is getting locked by concurrent sessions leading to a deadlock condition.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"