RE: lock type of analyze
- From: "Aggarwal, Meenakshi" <Meenakshi.Aggarwal@xxxxxxxxxxxxx>
- To: <raja4list@xxxxxxxxx>
- Date: Fri, 5 Aug 2005 11:36:16 -0400
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On
Behalf Of raja rao
Sent: Thursday, August 04, 2005 12:52 AM
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 <http://us.rd.yahoo.com/evt=34442/*http://www.yahoo.com/r/hs> your day
with Yahoo! - make it your home page
Other related posts:
