From lerobe@acxiom.co.uk Wed, 30 May 2001 10:03:01 -0700
From: Robertson Lee - lerobe <lerobe@acxiom.co.uk>
Date: Wed, 30 May 2001 10:03:01 -0700
Subject: RE: Analyze table and locking
Message-ID: <F001.00313BBD.20010530090646@fatcity.com>
MIME-Version: 1.0
Content-Type: text/plain



Many 
thanks


  <FONT face=Tahoma 
  size=2>-----Original Message-----From: Riyaj_Shamsudeen@i2.com 
  [mailto:Riyaj_Shamsudeen@i2.com]Sent: 30 May 2001 
  17:10To: Multiple recipients of list ORACLE-LSubject: 
  RE: Analyze table and locking<FONT face=sans-serif 
  size=2>Analyze index validate structure takes shared lock on the table 
  disallowing any changes to the table or indexes. That's the only way to 
  validate the structures. In 
  earlier versions (7.3 ?) 'analyze ..compute' used to take table level locks. 
  From 8 onwards, compute or estimate does not take any table level or row level 
  locks at all... ThanksRiyaj 
  "Re-yas" ShamsudeenCertified Oracle DBAi2 technologies   
  www.i2.com 
  
    
    
      
      Robertson Lee - lerobe 
        <lerobe@acxiom.co.uk> <FONT face=sans-serif 
        size=1>Sent by: root@fatcity.com 
        05/30/01 10:25 AM <FONT 
        face=sans-serif size=1>Please respond to ORACLE-L 
              <FONT 
        face=sans-serif size=1>        To:     
           Multiple recipients of list ORACLE-L 
        <ORACLE-L@fatcity.com> <FONT face=sans-serif 
        size=1>        cc:       
                
          Subject:        RE: Analyze table and 
        locking<FONT face="Courier New" 
  size=2>Ok, now I'm confused................One 
  reply---------It depends. For instance, 'analyze index validate 
  structure' takes out'shared' lock on the table (preventing 
  inserts/deletes/updates), while'analyze index compute/estimate statistics' 
  does not.Another-------Compute option locks a table, but 
  'estimate' doesn'tAnyone have a definitive answer.PS. Thanks 
  to the guys who have replied up to now.LeeThe 
  information contained in this communication isconfidential, is intended 
  only for the use of the recipientnamed above, and may be legally 
  privileged. If the reader of this message is not the intended recipient, 
  you arehereby notified that any dissemination, distribution orcopying 
  of this communication is strictly prohibited.  If you have received 
  this communication in error, please re-send this communication to the 
  sender and delete the original message or any copy of it from your 
  computersystem.-- Please see the official ORACLE-L FAQ: 
  http://www.orafaq.com-- Author: Robertson Lee - lerobe INET: 
  lerobe@acxiom.co.ukFat City Network Services    -- (858) 
  538-5051  FAX: (858) 538-5051San Diego, California     
     -- Public Internet access / Mailing 
  Lists--------------------------------------------------------------------To 
  REMOVE yourself from this mailing list, send an E-Mail messageto: 
  ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and inthe message 
  BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing 
  list you want to be removed from).  You mayalso send the HELP command 
  for other information (like 
subscribing).