RE: lock type of analyze

From: Aggarwal, Meenakshi <Meenakshi.Aggarwal_at_fishersci.com>
Date: Fri, 5 Aug 2005 11:36:16 -0400
Message-ID: <32729C17301C744582A747BD41569C120343F7EE@PGHCR-EXMB-VS-1.na.fshrnet.com>

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

--

http://www.freelists.org/webpage/oracle-l Received on Fri Aug 05 2005 - 10:38:20 CDT