> 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
Rick:
I've had problems trying to "slip in" an analyze on an index during
production hours. Our on-line users will see timeouts if the analyze is
lengthy. I assume analyze table will cause the same problem.
I decided to prove my case by analyzing a table and the looking for locks.
I didn't see
Update to posting:
Apparently locks preventing DML are only place if using validate structure.
Rick
Rick_Cale@team