From oracle-l-bounce@freelists.org  Wed Aug  3 23:53:54 2005
Return-Path: <oracle-l-bounce@freelists.org>
Received: from air891.startdedicated.com (root@localhost)
 by orafaq.com (8.12.10/8.12.10) with ESMTP id j744rsM2024525
 for <oracle-l@orafaq.com>; Wed, 3 Aug 2005 23:53:54 -0500
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 j744rnIP024511
 for <oracle-l@orafaq.com>; Wed, 3 Aug 2005 23:53:50 -0500
Received: from localhost (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 73FBA1DBFB7;
 Wed,  3 Aug 2005 23:53:44 -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 00505-09; Wed, 3 Aug 2005 23:53:44 -0500 (EST)
Received: from turing (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id ECEA51DC097;
 Wed,  3 Aug 2005 23:53:43 -0500 (EST)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=yahoo.com;
  h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding;
  b=YEliY+BsC5vMiYlSLmJ6u/K6YnVCGwaN9WQIO5raf6bm9ZLaRfYVY7QpYSL7wG0kXKTD9H283Lqxb2XqhFieQMjkPTIW0N6vIPPIVkg+ORuEx/x3LUJynCJ2Y2FbAM6fk3x+Qfngt+RFvgxDGksX5KO1xLwst97dzoFZeEqbBD0=  ;
Message-ID: <20050804045152.3249.qmail@web31402.mail.mud.yahoo.com>
Date: Wed, 3 Aug 2005 21:51:51 -0700 (PDT)
From: raja rao <raja4list@yahoo.com>
Subject: lock type of analyze
To: oracle-l@freelists.org
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-1494205893-1123131111=:2977"
X-archive-position: 23342
X-ecartis-version: Ecartis v1.0.0
Sender: oracle-l-bounce@freelists.org
Errors-To: oracle-l-bounce@freelists.org
X-original-sender: raja4list@yahoo.com
Precedence: normal
Reply-To: raja4list@yahoo.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.6 required=5.0 tests=AWL,BAYES_00,
 FORGED_YAHOO_RCVD,HTML_MESSAGE autolearn=no version=2.63
--0-1494205893-1123131111=:2977
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

HI All,
 
Does the analyze table compute statistics (or dbms_stats) statement  lock the table 
in anymode  
 
Thanks,
Raj

		
---------------------------------
 Start your day with Yahoo! - make it your home page 
--0-1494205893-1123131111=:2977
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

<DIV>HI All,</DIV>
<DIV>&nbsp;</DIV>
<DIV>Does the analyze table compute statistics (or dbms_stats) statement&nbsp; lock the table </DIV>
<DIV>in anymode&nbsp; </DIV>
<DIV>&nbsp;</DIV>
<DIV>Thanks,</DIV>
<DIV>Raj</DIV><p>
		<hr size=1> <a href="http://us.rd.yahoo.com/evt=34442/*http://www.yahoo.com/r/hs">Start your day with Yahoo! - make it your home page </a>
--0-1494205893-1123131111=:2977--
--
http://www.freelists.org/webpage/oracle-l