RE: Analyze table and locking
Thought of trying this out... I analyzed a huge table in our system and simultaneously checked for locks... Oracle did not lock the concerned table being analysed, but aquired locks on sys tables for sometime, both in estimate and compute options. On oracle 8.1.7. rgds amar -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 31, 2001 6:35 AM To: Multiple recipients of list ORACLE-L Christopher, Is this document perhaps a TAR as I cannot find it on Metalink (but maybe the search engine doesn't like me today). Do you have the exact URL for this note 213220.999? Thanks, Bruce -Original Message- Sent: Thursday, 31 May 2001 6:59 To: Multiple recipients of list ORACLE-L Oracle actually claims this statement. There are numerous docs stating this, for example DOC ID: 213220.999. But I agree 100% with Jeremiah's claims, in fact it can be verified very easily looking at v$lock while analyzing a large table. (I have actually done this in the past and present) and there are no locks under my current sid or any additional locks under any sid during analyze. Take any table that takes more than 3-4 seconds to analyze and in another window query V$LOCKS and you can see this first hand. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Wednesday, May 30, 2001 2:21 PM To: Multiple recipients of list ORACLE-L 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Amar Kumar Padhi 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:
RE: Analyze table and locking
It is a forum post I believe, I think I did a search on analyze lock. I have seen numerous articles were Oracle claims locking during analyze, that is the only one I found with quick parusal. Like many other things, Oracle is to blame on this old wives tale. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 30, 2001 10:35 PM To: Multiple recipients of list ORACLE-L Christopher, Is this document perhaps a TAR as I cannot find it on Metalink (but maybe the search engine doesn't like me today). Do you have the exact URL for this note 213220.999? Thanks, Bruce -Original Message- Sent: Thursday, 31 May 2001 6:59 To: Multiple recipients of list ORACLE-L Oracle actually claims this statement. There are numerous docs stating this, for example DOC ID: 213220.999. But I agree 100% with Jeremiah's claims, in fact it can be verified very easily looking at v$lock while analyzing a large table. (I have actually done this in the past and present) and there are no locks under my current sid or any additional locks under any sid during analyze. Take any table that takes more than 3-4 seconds to analyze and in another window query V$LOCKS and you can see this first hand. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Wednesday, May 30, 2001 2:21 PM To: Multiple recipients of list ORACLE-L 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
RE: Analyze table and locking
Yes, the library cache object is locked so it is not dropped during an analyze. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Thursday, May 31, 2001 5:25 AM To: Multiple recipients of list ORACLE-L Thought of trying this out... I analyzed a huge table in our system and simultaneously checked for locks... Oracle did not lock the concerned table being analysed, but aquired locks on sys tables for sometime, both in estimate and compute options. On oracle 8.1.7. rgds amar -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 31, 2001 6:35 AM To: Multiple recipients of list ORACLE-L Christopher, Is this document perhaps a TAR as I cannot find it on Metalink (but maybe the search engine doesn't like me today). Do you have the exact URL for this note 213220.999? Thanks, Bruce -Original Message- Sent: Thursday, 31 May 2001 6:59 To: Multiple recipients of list ORACLE-L Oracle actually claims this statement. There are numerous docs stating this, for example DOC ID: 213220.999. But I agree 100% with Jeremiah's claims, in fact it can be verified very easily looking at v$lock while analyzing a large table. (I have actually done this in the past and present) and there are no locks under my current sid or any additional locks under any sid during analyze. Take any table that takes more than 3-4 seconds to analyze and in another window query V$LOCKS and you can see this first hand. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Wednesday, May 30, 2001 2:21 PM To: Multiple recipients of list ORACLE-L 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com --
RE: Analyze table and locking
Yes, table is exclusively locked when ANALYZE ... VALIDATE. Until 9i, I believe. Vadim Gorbounov Oracle DBA -Original Message-From: Robertson Lee - lerobe [mailto:[EMAIL PROTECTED]]Sent: Wednesday, May 30, 2001 7:22 AMTo: Multiple recipients of list ORACLE-LSubject: 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.
RE: Analyze table and locking
Hi Lee, Compute option locks a table, but 'estimate' doesn't Regards, Ed -Original Message- Sent: 30 ??? 2001 ?. 15:22 To: Multiple recipients of list ORACLE-L 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 is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying 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 computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shevtsov, Eduard 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).
RE: Analyze table and locking
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't Anyone have a definitive answer. PS. Thanks to the guys who have replied up to now. Lee The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying 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 computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe 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).
RE: Analyze table and locking
I think thats the reason why we have two options - Estimate and Compute Statistics. Rajaram. -Original Message- From: Robertson Lee - lerobe [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, May 30, 2001 7:22 AM To: Multiple recipients of list ORACLE-L Subject:Analyze table and locking All, Just a quicky !! Anyone know if there are any locking issues while analyzing statistics for objects ?? TIA Lee NetZero Platinum No Banner Ads and Unlimited Access Sign Up Today - Only $9.95 per month! http://www.netzero.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajaram 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).
Re: Analyze table and locking
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-4627[EMAIL PROTECTED] - 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.
RE: Analyze table and locking
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... Thanks Riyaj Re-yas Shamsudeen Certified Oracle DBA i2 technologies www.i2.com Robertson Lee - lerobe [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/30/01 10:25 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Analyze table and locking 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't Anyone have a definitive answer. PS. Thanks to the guys who have replied up to now. Lee The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying 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 computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe 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).
Re: Analyze table and locking
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. Raghu. From: Robertson Lee - lerobe [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Analyze table and locking Date: Wed, 30 May 2001 03:21:46 -0800 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 is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying 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 computer system. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota 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).
RE: Analyze table and locking
Not necessarily. 8i+ DOESN'T require _ANY_ lock to COMPUTE while collecting statistics (99.99% of total operation time). It needs short lock to start and complete analyze. Regards Vadim -Original Message- Sent: Wednesday, May 30, 2001 9:07 AM To: Multiple recipients of list ORACLE-L Hi Lee, Compute option locks a table, but 'estimate' doesn't Regards, Ed -Original Message- Sent: 30 ??? 2001 ?. 15:22 To: Multiple recipients of list ORACLE-L 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 is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying 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 computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shevtsov, Eduard 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vadim Gorbounov 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).
RE: Analyze table and locking
Many thanks -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: 30 May 2001 17:10To: Multiple recipients of list ORACLE-LSubject: RE: Analyze table and lockingAnalyze 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 [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/30/01 10:25 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Analyze table and lockingOk, now I'm confusedOne 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 - lerobeINET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (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 subscribing).
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 [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).
RE: Analyze table and locking
At 8:10 -0800 30/5/01, [EMAIL PROTECTED] wrote: 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... Sorry, not true. From at least 7.2.3 (the oldest I have here) there was no table-level locking for any analyze statement. As for the preferment for estimate, Oracle has the last laugh - if you estimate on a percentage greater than 50% or specify rows greater than half the number of rows in the table, Oracle analyzes the entire table. Regards Paul Miller -- - Carib Data Limited mailto:[EMAIL PROTECTED] http://www.caribdata.co.uk -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: PD Miller 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).
RE: Analyze table and locking
Oracle actually claims this statement. There are numerous docs stating this, for example DOC ID: 213220.999. But I agree 100% with Jeremiah's claims, in fact it can be verified very easily looking at v$lock while analyzing a large table. (I have actually done this in the past and present) and there are no locks under my current sid or any additional locks under any sid during analyze. Take any table that takes more than 3-4 seconds to analyze and in another window query V$LOCKS and you can see this first hand. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Wednesday, May 30, 2001 2:21 PM To: Multiple recipients of list ORACLE-L 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence 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).
RE: Analyze table and locking
nice to see you posting again :) Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Wednesday, May 30, 2001 4:03 PM To: Multiple recipients of list ORACLE-L At 8:10 -0800 30/5/01, [EMAIL PROTECTED] wrote: 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... Sorry, not true. From at least 7.2.3 (the oldest I have here) there was no table-level locking for any analyze statement. As for the preferment for estimate, Oracle has the last laugh - if you estimate on a percentage greater than 50% or specify rows greater than half the number of rows in the table, Oracle analyzes the entire table. Regards Paul Miller -- - Carib Data Limited mailto:[EMAIL PROTECTED] http://www.caribdata.co.uk -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: PD Miller 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence 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).
RE: Analyze table and locking
Oracle actually claims this statement. There are numerous docs stating this, for example DOC ID: 213220.999. But I agree 100% with Jeremiah's claims, in fact it can be verified very easily looking at v$lock while analyzing a large table. (I have actually done this in the past and present) and there are no locks under my current sid or any additional locks under any sid during analyze. Take any table that takes more than 3-4 seconds to analyze and in another window query V$LOCKS and you can see this first hand. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Wednesday, May 30, 2001 2:21 PM To: Multiple recipients of list ORACLE-L 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence 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).
RE: Analyze table and locking
Yes, thats true... you need a lock on an object only when you are changing the object. So, analyze table does not have anything to do with locks.. Rajaram. -Original Message- From: Christopher Spence [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, May 30, 2001 4:31 PM To: Multiple recipients of list ORACLE-L Subject:RE: Analyze table and locking Oracle actually claims this statement. There are numerous docs stating this, for example DOC ID: 213220.999. But I agree 100% with Jeremiah's claims, in fact it can be verified very easily looking at v$lock while analyzing a large table. (I have actually done this in the past and present) and there are no locks under my current sid or any additional locks under any sid during analyze. Take any table that takes more than 3-4 seconds to analyze and in another window query V$LOCKS and you can see this first hand. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Wednesday, May 30, 2001 2:21 PM To: Multiple recipients of list ORACLE-L 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence 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). NetZero Platinum No Banner Ads and Unlimited Access Sign Up Today - Only $9.95 per month! http://www.netzero.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajaram 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).
RE: Analyze table and locking
Sorry but it is true. I have a 7.3.3 database and if it can't acquire a table lock it cannot do the compute. -Original Message- Sent: Wednesday, May 30, 2001 1:03 PM To: Multiple recipients of list ORACLE-L At 8:10 -0800 30/5/01, [EMAIL PROTECTED] wrote: 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... Sorry, not true. From at least 7.2.3 (the oldest I have here) there was no table-level locking for any analyze statement. As for the preferment for estimate, Oracle has the last laugh - if you estimate on a percentage greater than 50% or specify rows greater than half the number of rows in the table, Oracle analyzes the entire table. Regards Paul Miller -- - Carib Data Limited mailto:[EMAIL PROTECTED] http://www.caribdata.co.uk -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: PD Miller 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith 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).
RE: Analyze table and locking
It could be a bug with my version... I don't think it actually keeps a lock but it wants to be able to get the lock. For the most part we don't get our analyzes in due to this. Fortunately for me, we no longer want to and have deleted the stats. -Original Message- Sent: Wednesday, May 30, 2001 1:59 PM To: Multiple recipients of list ORACLE-L Oracle actually claims this statement. There are numerous docs stating this, for example DOC ID: 213220.999. But I agree 100% with Jeremiah's claims, in fact it can be verified very easily looking at v$lock while analyzing a large table. (I have actually done this in the past and present) and there are no locks under my current sid or any additional locks under any sid during analyze. Take any table that takes more than 3-4 seconds to analyze and in another window query V$LOCKS and you can see this first hand. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Wednesday, May 30, 2001 2:21 PM To: Multiple recipients of list ORACLE-L 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith 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).
Re: Analyze table and locking
On May 30, 2001 03:21 pm, Jeremiah Wilton wrote: 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? Any estimate over 50 will do a full compute. Doesn't require a lock on the table, however. Cheers, GC -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gregory Conron 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).
RE: Analyze table and locking
Christopher, Is this document perhaps a TAR as I cannot find it on Metalink (but maybe the search engine doesn't like me today). Do you have the exact URL for this note 213220.999? Thanks, Bruce -Original Message- Sent: Thursday, 31 May 2001 6:59 To: Multiple recipients of list ORACLE-L Oracle actually claims this statement. There are numerous docs stating this, for example DOC ID: 213220.999. But I agree 100% with Jeremiah's claims, in fact it can be verified very easily looking at v$lock while analyzing a large table. (I have actually done this in the past and present) and there are no locks under my current sid or any additional locks under any sid during analyze. Take any table that takes more than 3-4 seconds to analyze and in another window query V$LOCKS and you can see this first hand. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Wednesday, May 30, 2001 2:21 PM To: Multiple recipients of list ORACLE-L 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) 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).