From oracle-l-bounce@freelists.org Mon Jun 27 04:24:54 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j5R9Orud016652 for ; Mon, 27 Jun 2005 04:24:53 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180] (may be forged)) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j5R9OhIP016628 for ; Mon, 27 Jun 2005 04:24:43 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 686C31C49BF; Mon, 27 Jun 2005 03:21:13 -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 21179-09; Mon, 27 Jun 2005 03:21:13 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E258F1C4907; Mon, 27 Jun 2005 03:21:12 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:from:to:references:subject:date:mime-version:content-type:content-transfer-encoding:x-priority:x-msmail-priority:x-mailer:x-mimeole; b=ulyAKnlOprOetcZV/8AA5V0YgDBTECjiRfSXCTK31FV760Wk/Jl3pf2heWUfDoYKyfeDHjjfrw/7jJ0B7g3RsPXQqVJQVtrgUqFoCmg1tq8KO6ocwS8HH/BZKKU8Xw05Vve4xhVXaiZrDf1nMSj1AJcD+hef+GR0Hx00pmTR8Sw= Message-ID: <00af01c57af0$f059e4d0$1a03310a@IBME1D11967173> From: "Radoulov, Dimitre" To: , References: <161657AE46CE0740BAC823B28AE90AFC1F2977@CERO-EXBE-01.USG.NET> <1119678424l.9138l.0l@medo.noip.com> <1119715976l.4712l.0l@medo.noip.com> Subject: Re: ORA-600 Deadlock Issues Date: Mon, 27 Jun 2005 10:19:26 +0200 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527 X-archive-position: 21704 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: cichomitiko@gmail.com Precedence: normal Reply-To: cichomitiko@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-3.9 required=5.0 tests=AWL,BAYES_00 autolearn=ham version=2.63 > look up chapter 7 of tom kytes' book - Indexes on Foreign Keys. (page 142 > in my book). > > "The number one cause of deadlocks in the Oracle database, in my > experience, is unindexed foreign keys" - says the Guru himself. The next time you have a deadlock, check first the deadlock graph, for unindexed foregn keys it will be SX-SSX: Deadlock graph: ---------Blocker(s)-------- ---------Waiter(s)--------- Resource Name process session holds waits process session holds waits TM-000010e0-00000000 14 40 SX SSX 13 19 SX SSX TM-000010e0-00000000 13 19 SX SSX 14 40 SX SSX session 40: DID 0001-000E-00000002 session 19: DID 0001-000D-00000002 session 19: DID 0001-000D-00000002 session 40: DID 0001-000E-00000002 Cheers Dimitre Radoulov -- http://www.freelists.org/webpage/oracle-l