From ineyman@perceptron.com Wed, 30 May 2001 07:56:03 -0700 From: "Igor Neyman" Date: Wed, 30 May 2001 07:56:03 -0700 Subject: Re: Analyze table and locking Message-ID: MIME-Version: 1.0 Content-Type: text/plain It depends. For instance, 'analyze index validate structure' takes out 'shared' lock on the table (preventing inserts/deletes/updates), while 'analyze index compute/estimate statistics' does not. For more info see 'Practical Oracle 8i' by Jonathan Lewis - very good book.   Igor Neyman, OCP DBAPerceptron, Inc.(734)414-4627ineyman@perceptron.com 
----- Original Message -----
From: Robertson Lee - lerobe To: Multiple recipients of list ORACLE-L Sent: Wednesday, May 30, 2001 7:21 AM Subject: Analyze table and locking All,   Just a quicky !!   Anyone know if there are any locking issues while analyzing statistics for objects ??   TIA   Lee  The information contained in this communication isconfidential, is intended only for the use of the recipientnamed above, and may be legally privileged. If the reader of this message is not the intended recipient, you arehereby notified that any dissemination, distribution orcopying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computersystem.