RE: Analyze table and locking

From: Vadim Gorbounov <vgorbounov_at_simplyengineering.com>
Date: Wed, 30 May 2001 06:36:58 -0700
Message-ID: <F001.0031370A.20010530063021@fatcity.com>

Yes,
table is exclusively locked when ANALYZE ... VALIDATE. Until 9i, I believe.
Vadim
Gorbounov
Oracle
DBA
<FONT face=Tahoma

  size=2>-----Original Message-----From: Robertson Lee - lerobe   [mailto:lerobe_at_acxiom.co.uk]Sent: Wednesday, May 30, 2001 7:22   AMTo: Multiple recipients of list ORACLE-LSubject:   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 - 08:36:58 CDT