Re: Deadlock resolution

From: Galen Boyer <galenboyer_at_hotpop.com>
Date: 19 Feb 2004 11:12:17 -0600
Message-ID: <un07fro7j.fsf@standardandpoors.com>

On Mon, 16 Feb 2004, newspostings_at_hazelweb.co.uk wrote:
> Are there any tips & tricks folks have for resolving deadlocks
> reported in the alert log files?
>
> Currently on 8.1.7.4

I've found that you have to walk through you database access code and make sure you've ordered all access the same way. If you have implemented subtypes within your database design, these can cause deadlock headaches as well.

The hard thing is that Oracle doesn't tell you what objects were involved in the deadlock, and it can be anything.

Good luck. Your codebase will be more solid when you solve it. It should invariably be an application design/coding issue.

-- 
Galen Boyer

Received on Thu Feb 19 2004 - 11:12:17 CST