RE: lock type of analyze

From: Lex de Haan <lex.de.haan_at_naturaljoin.nl>
Date: Thu, 4 Aug 2005 10:32:04 +0200
Message-Id: <20050804083205.BA5351DC552@turing.freelists.org>

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of raja rao
Sent: Thursday, August 04, 2005 06:52
To: oracle-l_at_freelists.org
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

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Aug 04 2005 - 03:34:09 CDT