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: Having Deadlock Problem

Re: Having Deadlock Problem

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 7 Jun 2004 19:11:46 +0000 (UTC)
Message-ID: <ca2eli$a7o$1@sparta.btinternet.com>

Note in-line:

-- 
Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk

http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/seminar.html
Optimising Oracle Seminar - schedule updated May 1st


<ctcgag_at_hotmail.com> wrote in message
news:20040607133244.056$iW_at_newsreader.com...

> "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:
>
> From the holds-waits list in the trace file, it looks like
> there there is one extra transaction in the mix, but that there
> isn't a closed loop. I.e, session 13 is blocking 20, and 20 is
> blocking 43, but there is no indication that 43 is blocking 13.
>
> Am I misinterpreting something here?
No - you're right. I didn't look closely enough at the graph. It's possible that the absence of a closed loop corroborates the distributed nature of problem. I'll have to play around with a few examples when I have some time.
>
> Thanks,
>
> Xho
>
Received on Mon Jun 07 2004 - 14:11:46 CDT

Original text of this message

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