Re: Analyze table and locking

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. For more info see 'Practical Oracle 8i' by Jonathan Lewis - very good book.
 
Igor Neyman, OCP DBAPerceptron, Inc.(734)414-4627<A href="mailto:ineyman_at_perceptron.com">ineyman_at_perceptron.com 

<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

• Original Message -----
  <DIV
  style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From: Robertson Lee - lerobe To: <A title=ORACLE-L_at_fatcity.com href="mailto:ORACLE-L_at_fatcity.com">Multiple recipients of list ORACLE-L

  Sent: Wednesday, May 30, 2001 7:21
  AM
  Subject: Analyze table and locking   

<SPAN

  class=187252310-30052001>All,
<SPAN

  class=187252310-30052001> 
  Just a quicky
  !!
<SPAN

  class=187252310-30052001> 
  Anyone know if
  there are any locking issues while analyzing statistics for objects   ??
<SPAN

  class=187252310-30052001> 
<SPAN

  class=187252310-30052001>TIA
<SPAN

  class=187252310-30052001> 
<SPAN

  class=187252310-30052001>Lee   

   The 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. Received on Wed May 30 2001 - 09:56:03 CDT