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