Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Deadlock resolution

Re: Deadlock resolution

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Mon, 16 Feb 2004 12:21:46 -0800
Message-ID: <1076962863.434612@yasure>


Jeremy wrote:

> Are there any tips & tricks folks have for resolving deadlocks reported
> in the alert log files?
>
> Currently on 8.1.7.4

Design better schemas and write better code.

Deadlocks in a properly designed schema in which appropriate code is written are so rare as to be almost unworthy of comment.

The first thing to ask is "What is causing the deadlocks"? What business process is being supported by what code?

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Mon Feb 16 2004 - 14:21:46 CST

Original text of this message

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