Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 2857 invoked from network); 21 Dec 2007 10:37:41 -0600 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by static-ip-69-64-49-119.inaddr.intergenia.de with SMTP; 21 Dec 2007 10:37:41 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C795A7DE150; Fri, 21 Dec 2007 11:37:40 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 29436-05; Fri, 21 Dec 2007 11:37:40 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 434A47DE123; Fri, 21 Dec 2007 11:37:40 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 21 Dec 2007 10:50:16 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1239F7DDB2C for ; Fri, 21 Dec 2007 10:50:16 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 22804-06 for ; Fri, 21 Dec 2007 10:50:15 -0500 (EST) Received: from outbound10-sin-R.bigfish.com (outbound-sin.frontbridge.com [207.46.51.80]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id EBC187DDB01 for ; Fri, 21 Dec 2007 10:50:13 -0500 (EST) Received: from outbound10-sin.bigfish.com (localhost.localdomain [127.0.0.1]) by outbound10-sin-R.bigfish.com (Postfix) with ESMTP id 9C5941851BCC; Fri, 21 Dec 2007 15:44:04 +0000 (UTC) Received: from mail164-sin-R.bigfish.com (unknown [10.3.40.3]) by outbound10-sin.bigfish.com (Postfix) with ESMTP id 7CF011980051; Fri, 21 Dec 2007 15:44:04 +0000 (UTC) Received: from mail164-sin (localhost.localdomain [127.0.0.1]) by mail164-sin-R.bigfish.com (Postfix) with ESMTP id 88F7DB101AC; Fri, 21 Dec 2007 15:44:37 +0000 (UTC) X-BigFish: VP X-MS-Exchange-Organization-Antispam-Report: OrigIP: 12.41.53.16;Service: EHS Received: by mail164-sin (MessageSwitch) id 1198251877544737_12297; Fri, 21 Dec 2007 15:44:37 +0000 (UCT) Received: from dsmtpg02.col.discoverfinancial.com (dsmtpg02.col.discoverfinancial.com [12.41.53.16]) (using TLSv1 with cipher EDH-RSA-DES-CBC3-SHA (168/168 bits)) (No client certificate requested) by mail164-sin.bigfish.com (Postfix) with ESMTP id EADDE152004E; Fri, 21 Dec 2007 15:44:36 +0000 (UTC) Received: from dfscolm02.co.discoverfinancial.com (dfscolm02.co.discoverfinancial.com [199.12.96.170]) by dsmtpg02.co.discoverfinancial.com with ESMTP id lBLFhhl651350; Fri, 21 Dec 2007 10:43:43 -0500 In-Reply-To: <007501c84376$3d4fc8e0$6401a8c0@BHAIRAVIPC01> Subject: RE: Do selects block truncates? To: Cc: "'oracle-l'" Message-ID: From: genegurevich@discover.com Date: Fri, 21 Dec 2007 09:43:59 -0600 X-MIMETrack: Serialize by Router on DFSCOLM02/MSRV/DFSI(Release 7.0.1FP1|April 17, 2006) at 12/21/2007 09:44:00 MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII X-archive-position: 4090 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: genegurevich@discover.com Precedence: normal Reply-to: genegurevich@discover.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: Debian amavisd-new at localhost.localdomain I have executed the following SQL, which indicated that two of my truncate sessions were waiting on the same session. When I looked at what was running by that session it was a select thank you Gene Gurevich Oracle MySQL Operations - OMO 224-405-4079 To 12/20/2007 08:07 , PM "'oracle-l'" cc Please respond to RE: Do selects block truncates? Perhaps, what I am about to say has already been considered and ruled out. That said, how was the conclusion drawn that the statement that is in execution is the statement that is blocking the other two. If this has not been ruled out then I would try to ensure that no other DML is pending form the "other" session (ASH, v$transaction, etc). I tend to look for the simpler explanation first before I take the red pill to find out how deep the rabbit hole is. -Krish -- http://www.freelists.org/webpage/oracle-l