Re: how synchronous is Oracle?

From: Richard Kuhler <noone_at_nowhere.com>
Date: Thu, 06 Mar 2003 21:33:01 GMT
Message-ID: <h8P9a.45221$aa.13437046@twister.socal.rr.com>

Oracle can also lock a table to enforce referential integrity if child table indexes aren't created. Oracle can also block an update if the transaction entries are all used in a block and either maxtrans is reached or there is no free space left in the block.

I'm sure there are several of other exceptions to his blanket statements.

That never word always seems to cause problems. ;)

Richard

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.
>
> Cheers,
> Tanel.
Received on Thu Mar 06 2003 - 15:33:01 CST