Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: how synchronous is Oracle?
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.
Cheers,
Tanel.
Received on Thu Mar 06 2003 - 13:36:33 CST