Re: deadlock detection/resolving

From: Knut Talman <knut.talman_at_mytoys.de>
Date: Fri, 19 Apr 2002 17:50:23 +0200
Message-ID: <3CC03CBF.1040607@mytoys.de>

> - there are only two connections
> (started with benthic-software "golden")
> t1:
> update artikel set bezeichnung = 'WURST'
> where artnr = 127493;
> t2:
> update artikel set bezeichnung = 'WURST'
> where artnr = 127494;
> t1:
> update artikel set bezeichnung = 'KÄSE'
> where artnr = 127494;
> t2:
> update artikel set bezeichnung = 'KÄSE'
> where artnr = 127493;
>
>
> --> look at the artnr !!

I look at the bezeichnung and all I can say is: "Iss doch eh alles Wurst, oder?"

> now there's a deadlock! all that I want is that oracle
> resolves it automatic...

As your alert.log tells you, Oracle did resolve it by rolling back your transactions.

Regards,

Knut Received on Fri Apr 19 2002 - 10:50:23 CDT