Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: how synchronous is Oracle?

Re: how synchronous is Oracle?

From: Andrew Allen <andrew.allen_at_sppaammkiller.handleman.com>
Date: Thu, 06 Mar 2003 22:01:00 GMT
Message-ID: <3E67B817.2020502@sppaammkiller.handleman.com>


Tanel Poder wrote:
> Hi,
>
>

>>Uwe,
>>You DO NOT know what you are talking about.
>>1. Oracle DOES NOT ever lock tables.  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.

>
>
> 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. Received on Thu Mar 06 2003 - 16:01:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US