RE: lock type of analyze

no, they don't. however, as far as I know, the "analyze ... validate structure"
command locks the underlying object.
 
hope this helps,


kind regards,

Lex.

------------------------------------------------------------------
Steve Adams Seminar  <http://www.naturaljoin.nl/events/seminars.html>
http://www.naturaljoin.nl/events/seminars.html
------------------------------------------------------------------ 

 

  _____  

From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of raja rao
Sent: Thursday, August 04, 2005 06:52
To: oracle-l@xxxxxxxxxxxxx
Subject: lock type of analyze


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


  _____  

Start your  <http://us.rd.yahoo.com/evt=34442/*http://www.yahoo.com/r/hs> day
with Yahoo! - make it your home page 

BEGIN:VCARD
VERSION:2.1
N:de Haan;Lex
FN:Lex de Haan
ORG:Natural Join B.V.
TEL;WORK;VOICE:+31.30.2515022
TEL;HOME;VOICE:+31.30.2518795
TEL;CELL;VOICE:+31.62.2955714
TEL;WORK;FAX:+31.30.2523366
ADR;WORK:;;Pieter Breughelstraat 10;Utrecht;;3583 SK;Netherlands
LABEL;WORK;ENCODING=QUOTED-PRINTABLE:Pieter Breughelstraat 10=0D=0AUtrecht 3583 
SK=0D=0ANetherlands
URL;WORK:http://www.naturaljoin.nl
EMAIL;PREF;INTERNET:lex.de.haan@xxxxxxxxxxxxxx
REV:20040224T160439Z
END:VCARD

Other related posts: