From jwilton@speakeasy.net Wed, 30 May 2001 10:41:13 -0700 From: Jeremiah Wilton Date: Wed, 30 May 2001 10:41:13 -0700 Subject: Re: Analyze table and locking Message-ID: MIME-Version: 1.0 Content-Type: text/plain I have used compute statistics since version 7.3.2 up through 8.1.6, and never had it hold a table lock for the duration of the analyze. I don't know where people are getting the idea that compute statistics holds a lock and estimate doesn't. That just doesn't make sense. Why would compute need a lock? Are you saying I can estimate sample 99 percent, and get what amounts to a compute and avoid the supposed lock? Does that make any sense? No. Validate structure cascade holds a lock. The most the others do is grab some resource [very] briefly at the end to update the dictionary. People claiming that compute holds a lock, please post documentation to support that statement. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Wed, 30 May 2001, Raghu Kota wrote: > Yeah If you use compute statistics your table get locked and will take long > time, But If you use estimate statistics it will be fast But not as > accurate as before. Better to analyze at nights by setting time. > > >From: Robertson Lee - lerobe > > > >Anyone know if there are any locking issues while analyzing statistics for > >objects ?? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: jwilton@speakeasy.net Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).