Re: Deadlock resolution

From: Keith Jamieson <keith_jamieson_at_hotmail.com>
Date: Sat, 21 Feb 2004 21:13:42 -0000
Message-ID: <cSPZb.3804$rb.60689@news.indigo.ie>

Make sure you have your foreign keys indexed. Unindexed foreign keys are a major cause of deadlocks.

"Jeremy" <newspostings_at_hazelweb.co.uk> wrote in message news:MPG.1a9af9c43efcadbb989aba_at_news.individual.net...
> Are there any tips & tricks folks have for resolving deadlocks reported
> in the alert log files?
>
> Currently on 8.1.7.4
>
>
> --
>
> jeremy
Received on Sat Feb 21 2004 - 15:13:42 CST

This message: [ Message body ]
Next message: FC: "Re: fastest way to determine if 0 or more records are present in table?"
Previous message: Zaki Kashevarov: "Re: Oracle Spatial Attributes"
In reply to: Jeremy: "Deadlock resolution"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US