Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Having Deadlock Problem
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...Received on Mon Jun 07 2004 - 14:11:46 CDT
> "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
>