Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 877 invoked from network); 20 Dec 2007 11:59:12 -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; 20 Dec 2007 11:59:12 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1922F7DD6BA; Thu, 20 Dec 2007 12:59:12 -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 04315-06; Thu, 20 Dec 2007 12:59:11 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5F7057DD2EB; Thu, 20 Dec 2007 12:59:11 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 20 Dec 2007 12:57:02 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 962547DD430 for ; Thu, 20 Dec 2007 12:57:02 -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 03970-02 for ; Thu, 20 Dec 2007 12:57:02 -0500 (EST) Received: from outbound3-va3-R.bigfish.com (outbound-va3.frontbridge.com [216.32.180.16]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 70E737DBB1D for ; Thu, 20 Dec 2007 12:57:02 -0500 (EST) Received: from outbound3-va3.bigfish.com (localhost.localdomain [127.0.0.1]) by outbound3-va3-R.bigfish.com (Postfix) with ESMTP id 3657D14A0326 for ; Thu, 20 Dec 2007 17:57:02 +0000 (UTC) Received: from mail51-va3-R.bigfish.com (si1-va3 [10.7.14.5]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by outbound3-va3.bigfish.com (Postfix) with ESMTP id 34F06138006C for ; Thu, 20 Dec 2007 17:57:02 +0000 (UTC) Received: from mail51-va3 (localhost.localdomain [127.0.0.1]) by mail51-va3-R.bigfish.com (Postfix) with ESMTP id 153E11BF0471 for ; Thu, 20 Dec 2007 17:57:02 +0000 (UTC) X-BigFish: VP X-MS-Exchange-Organization-Antispam-Report: OrigIP: 12.41.53.18;Service: EHS Received: by mail51-va3 (MessageSwitch) id 119817342275666_4316; Thu, 20 Dec 2007 17:57:02 +0000 (UCT) Received: from dsmtpg04.col.discoverfinancial.com (unknown [12.41.53.18]) (using TLSv1 with cipher EDH-RSA-DES-CBC3-SHA (168/168 bits)) (No client certificate requested) by mail51-va3.bigfish.com (Postfix) with ESMTP id E1B0B1A8004D for ; Thu, 20 Dec 2007 17:57:01 +0000 (UTC) Received: from dfscolm02.co.discoverfinancial.com (dfscolm02.co.discoverfinancial.com [199.12.96.170]) by dsmtpg04.co.discoverfinancial.com with ESMTP id lBKHuRD311460 for ; Thu, 20 Dec 2007 12:56:27 -0500 In-Reply-To: <607D6181D9919041BE792D70EF2AEC482434DC@LIMENS.sivsa.int> Subject: Do selects block truncates? To: "oracle-l" Message-ID: From: genegurevich@discover.com Date: Thu, 20 Dec 2007 11:43:30 -0600 X-MIMETrack: Serialize by Router on DFSCOLM02/MSRV/DFSI(Release 7.0.1FP1|April 17, 2006) at 12/20/2007 11:55:36 MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII X-archive-position: 4044 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 Hi all: I am running oracle 10.2.0.2 and I see two sessions running truncate commands being stuck. It looks like they are waiting on another session which is currently running a long select. That select accesses both of the tables that the other two sessions are trying to truncate. I was not aware that a select can block a truncate. Is that the case or is there something else here which I am missing? thank you Gene Gurevich -- http://www.freelists.org/webpage/oracle-l