Re: Analyze table and locking

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 <lerobe_at_acxiom.co.uk>

> >

> >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_at_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_at_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).