RE: lock type of analyze

From: raja rao <raja4list_at_yahoo.com>
Date: Sat, 6 Aug 2005 07:32:46 -0700 (PDT)
Message-ID: <20050806143246.26294.qmail@web31409.mail.mud.yahoo.com>

Do we have ONLINE option (and for dbms_stats too ?) and what mekes the difference if I use ONLINE option.

"Aggarwal, Meenakshi" <Meenakshi.Aggarwal_at_fishersci.com> wrote: I guess analyze table compute statistics applies some kind of lock on the table unless used with online option.
-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of raja rao Sent: Thursday, August 04, 2005 12:52 AM 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 day with Yahoo! - make it your home page                 

---

Yahoo! Mail
 Stay connected, organized, and protected. Take the tour
--

http://www.freelists.org/webpage/oracle-l Received on Sat Aug 06 2005 - 09:34:45 CDT