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 -> Interpretting Deadlock Info

Interpretting Deadlock Info

From: Gene Hubert <110530.717_at_CompuServe.COM>
Date: Fri, 12 Mar 1999 11:26:00 -0500
Message-ID: <OgxBFUKb#GA.309@nih2naae.prod2.compuserve.com>


How do I intrepret this deadlock info from a trace file. I was able to determine the table and row from the last two lines, but don't know what to do with the rest of this. Gene Hubert, Qualex Inc., Durham, NC



ksqded1: deadlock detected via did

Deadlock graph:
(where pr=process,ss=session,hd=holds,wt=waits)
                       -Blocker(s)  -Waiter(s)-
Resource Name          pr ss hd wt  pr ss hd wt
TX-0006000f-00000253   15  8  X     11 17     X
TX-00070012-00000252   11 17  X     15  8     X

session 8: DID 0001-000F-00000001	session 17: DID 
0001-000B-00000001

session 17: DID 0001-000B-00000001 session 8: DID 0001-000F-00000001

Rows waited on:
Session 17: obj - rowid = 00002FFA - AAAC/6AAGAAAGHEAAa Session 8: obj - rowid = 00002FFA - AAAC/6AAGAAAGHNAAq Received on Fri Mar 12 1999 - 10:26:00 CST

Original text of this message

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