Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Deadlocks-a mystery
We've just found out, that an DELETE RESTRICT ref.int. rule causes also
Deadlocks.
I'm not sure if this implies only to our (Table) situation...
"Mr. Straits" wrote:
> All,
> We daily get over 5-6 deadlocks everyday and each of them are different. Our
> DBA forwards the trace file to me everyday. The trace file says that it is
> an application error and not an Oracle Error. After looking at the trace
> file, I can see what applications are contesting, but why do both the
> applications error out? My understanding is that when we get a deadlock,
> Oracle gives that 0054 error to only session and the other session should
> work normally.
> As I wrote earlier, its not always the same two applications. The
> applications are way different and the tables getting locked are also
> different. We are using Oracle 7.3.4.
> Any help on this is appreciated.
> Straits.
--
apartis AG http://www.apartis.deThilo Schunck
email: Thilo.Schunck_at_apartis.de
Tel. +49 (0)6721/9633-19
Fax +49 (0)6721/9633-29
Received on Wed Jan 26 2000 - 09:02:50 CST