> Prior to Oracle ver 9 , yes.It is an exclusive lock ...Oracle
> 9 has ONLINE
> option which allows DML while analyzing table...
Mohammed,
Have to differ with you on this - ANALYZE may place a DDL lock, but not a
DML lock. This would have otherwise severely restricted concurrency. Should
be e
Prior to Oracle ver 9 , yes.It is an exclusive lock ...Oracle 9 has ONLINE
option which allows DML while analyzing table...
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Thu, 12 Sep 2002 06:33:29 -0800
Hi DBAs,
I would like to a
rb
> --
> From: [EMAIL PROTECTED][SMTP:[EMAIL PROTECTED]]
> Reply To: [EMAIL PROTECTED]
> Sent: Thursday, September 12, 2002 8:33 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Does analyze table lock the tables
>
> Hi DBAs,
>
[EMAIL PROTECTED] Subject: Does analyze table lock the
tables
Hi DBAs,
I would like to analyze a few tables in production. My question does it
prevent any type of access i.e.,apply locks? If so I can wait to do it off
hours.
Thanks
Rick
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Netw
