From oracle-l-bounce@freelists.org Wed Feb 2 15:03:45 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j12L3i0Q024320 for ; Wed, 2 Feb 2005 15:03:44 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j12L3iem024316 for ; Wed, 2 Feb 2005 15:03:44 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id CCBA66C863; Wed, 2 Feb 2005 15:02:48 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 31305-07; Wed, 2 Feb 2005 15:02:48 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 521F26C662; Wed, 2 Feb 2005 15:02:48 -0500 (EST) Message-ID: <10347.85.224.139.74.1107374463.squirrel@glenlivet.oderland.com> In-Reply-To: <420106EA.2010600@dianoema.it> References: <420106EA.2010600@dianoema.it> Date: Wed, 2 Feb 2005 21:01:03 +0100 (CET) Subject: Re: How to identify resources in deadlock graph From: Kristian =?iso-8859-1?Q?Myllym=E4ki?= To: "Oracle-l" User-Agent: SquirrelMail/1.4.2 MIME-Version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - glenlivet.oderland.com X-AntiAbuse: Original Domain - freelists.org X-AntiAbuse: Originator/Caller UID/GID - [0 0] / [47 12] X-AntiAbuse: Sender Address Domain - kmja.com X-Source: X-Source-Args: X-Source-Dir: X-archive-position: 15703 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: kristian@kmja.com Precedence: normal Reply-To: kristian@kmja.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Checker-Version: SpamAssassin 2.60 (1.212-2003-09-23-exp) on air891.startdedicated.com X-Spam-Status: No, hits=0.0 required=5.0 tests=none autolearn=ham version=2.60 X-Spam-Level: We'll, as stated by the deadlock graph the other session is not waiting on a row lock, but probably an index lock since the lock type is TX. I would guess that either the both sessions are trying to use the same value in an unique index or that you might be using a bitmap index which uses a "row-range" type of lock which could lead to deadlocks when multiple sessions are executing DML. /Kristian > Hi all, > I have to diagnose a deadlock cause but I don't know how to extract all > information. > Here is an excerpt of the trace file: > Deadlock graph: > ---------Blocker(s)-------- > ---------Waiter(s)--------- > Resource Name process session holds waits process session > holds waits > TX-000b001c-0013e61f 207 52 X 215 100 > X > TX-001c002d-0013eb3b 215 100 X 207 52 > S > session 52: DID 0001-00CF-00000002 session 100: DID 0001-00D7-00000002 > session 100: DID 0001-00D7-00000002 session 52: DID 0001-00CF-00000002 > Rows waited on: > Session 100: obj - rowid = 00001700 - AAAFH4AAiAAAQ8xAAV > Session 52: no row > > The problem is on session 52, I have identified the object_id which > corresponds to 1700 hex, but I'm not able to determine the other > resource in the deadlock graph. > Any advice? > Thank in advance, > Giovanni > -- > > ---------------------------------------- > Giovanni Cuccu > Sw Engineer@dianoema.it > Dianoema S.p.A. > Via de' Carracci 93 40131 Bologna > Tel: 051-7098211 051-4193911 > e-mail:gcuccu@dianoema.it > ---------------------------------------- > No man does it all by himself, > I said young man, > put your pride on the shelf > ---------------------------------------- > -- > http://www.freelists.org/webpage/oracle-l > -- http://www.freelists.org/webpage/oracle-l