From oracle-l-bounce@freelists.org Wed Feb 2 12:15:32 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j12IFWSw029896 for ; Wed, 2 Feb 2005 12:15:32 -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 j12IFWem029892 for ; Wed, 2 Feb 2005 12:15:32 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 567C76C89C; Wed, 2 Feb 2005 12:14:37 -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 22199-01; Wed, 2 Feb 2005 12:14:37 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C9B996C79E; Wed, 2 Feb 2005 12:14:36 -0500 (EST) Message-ID: <420109F4.60403@dianoema.it> Date: Wed, 02 Feb 2005 18:12:20 +0100 From: Giovanni Cuccu User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Mladen Gogala Cc: Oracle-l Subject: Re: How to identify resources in deadlock graph References: <420106EA.2010600@dianoema.it> <42010931.7010703@allegientsystems.com> In-Reply-To: <42010931.7010703@allegientsystems.com> Content-type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-archive-position: 15688 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: gcuccu@dianoema.it Precedence: normal Reply-To: gcuccu@dianoema.it 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: Sorry, I have a trace file and the two sessions do not exist anymore. I'm wondering if I can extract these information from the trace file. Giovanni > Giovanni Cuccu wrote: > >> >> 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. >> >> > V$SESSION table contains the column named ROW_WAIT_OBJ# which can be > joined > to DBA objects. > -- ---------------------------------------- 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