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 <[EMAIL PROTECTED]>
> >
> >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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
