Re: how synchronous is Oracle?

From: Tanel Poder <tanel_at_@peldik.com>
Date: Fri, 7 Mar 2003 15:59:01 +0200
Message-ID: <3e68a4f5$1_2@news.estpak.ee>

> > 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.

In default configuration, it does not lock tables. But in some configuration it does, implicitly, without special instructions from application.

EOT.
Tanel. Received on Fri Mar 07 2003 - 07:59:01 CST