| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Analyze table and locking
Many
thanks
<FONT face=Tahoma
size=2>-----Original Message-----From: Riyaj_Shamsudeen_at_i2.com
[mailto:Riyaj_Shamsudeen_at_i2.com]Sent: 30 May 2001
17:10To: Multiple recipients of list ORACLE-LSubject:
RE: Analyze table and locking<FONT face=sans-serif
size=2>Analyze index validate structure takes shared lock on the table
disallowing any changes to the table or indexes. That's the only way to
validate the structures. In
earlier versions (7.3 ?) 'analyze ..compute' used to take table level locks.
From 8 onwards, compute or estimate does not take any table level or row level
locks at all... ThanksRiyaj
"Re-yas" ShamsudeenCertified Oracle DBAi2 technologies
www.i2.com
Robertson Lee - lerobe
<lerobe_at_acxiom.co.uk> <FONT face=sans-serif
size=1>Sent by: root_at_fatcity.com
05/30/01 10:25 AM <FONT
face=sans-serif size=1>Please respond to ORACLE-L
<FONT
face=sans-serif size=1> To:
Multiple recipients of list ORACLE-L
<ORACLE-L_at_fatcity.com> <FONT face=sans-serif
size=1> cc:
Subject: RE: Analyze table and
locking<FONT face="Courier New"
size=2>Ok, now I'm confused................One
reply---------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.Another-------Compute option locks a table, but
'estimate' doesn'tAnyone have a definitive answer.PS. Thanks
to the guys who have replied up to now.LeeThe
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.-- Please see the official ORACLE-L FAQ:
http://www.orafaq.com-- Author: Robertson Lee - lerobe INET:
lerobe_at_acxiom.co.ukFat City Network Services -- (858)
538-5051 FAX: (858) 538-5051San Diego, California
-- Public Internet access / Mailing
Lists--------------------------------------------------------------------ToREMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like
 |
 |