Re: How do you prevent Deadlocks

In article <jmboivin.23.000C201C_at_cti.ulaval.ca>, <jmboivin_at_cti.ulaval.ca> writes:
>
> I experienced VERY VERY big problems with deadlock in a application last
> summer. We worked hard to find WHY there was so many deadlock until somebody
> on this group send us a message telling us to index ALL foreign keys. We had
> many foreign keys not indexed. As soon as we index those keys all deadlock
> just disappear...
>
> Check this point, may be it could help you.
>
> Jean-Marc Boivin
> Universite Laval
> Quebec Canada
> jean.marc-boivin_at_sit.ulaval.ca
>

Could someone give an explanation for this? We just recently moved a Forms 3.0 based application from 7.0.12 to 7.1.3. We are now getting deadlocks in some of our testing that did not happen before (Oracle error # 60).

When we moved the data, we also moved the data and indexes into different table spaces. It doesn't seem to me that any of this should have an effect on deadlocks, but....

Anyone have any ideas / explanation?

Keith

Keith Moore, P.E.                            Minerva Technology
keith_at_kmoore.itg.ti.com                      3102 Maple Ave, # 240
(214) 575-3460                               Dallas, Tx 75201
------------------------------------------------------------------