Re: how synchronous is Oracle?

From: Andrew Allen <andrew.allen_at_sppaammkiller.handleman.com>
Date: Fri, 07 Mar 2003 14:01:42 GMT
Message-ID: <3E689946.8080403@sppaammkiller.handleman.com>

Tanel Poder wrote:
>>>Never say never.
>>>If you have parameter ROW_LOCKING set to INTENT, table level locks *are*
>>>aquired during an UPDATE operation.
>>>
>>
>><quote>
>> Against fools, the gods themselves contend in vain.
>> -- don't remember who
>><\end quote>

> 
> 
> Erm... you were saying?

"Applications can lock tables for update but Oracle DOES NOT EVER escallate locks to the block or table level. So, no matter how much data txt a inserts, updates, or deletes, txn b will NOT wait for txn a to commit or rollback. "

Is what I said. Of course you can play around with oracle, but in normal operation, oracle does not lock tables.

--
AjA

Received on Fri Mar 07 2003 - 08:01:42 CST