freas.art_at_ist.mds.lmco.com wrote:
>
> Question: Does oracle lock the entire table when you execute a commit
> We are wondering if we need to write a messaging layer in order to
> eliminate problems we may encounter if the table locks when we do the commit.
> Any help appreciated. Thanks much.
> ART
Unless you explicitly escalate the lock level, Oracle only locks rows
during a DML transaction, and will provide a read-consistent (before
image) view of the locked rows to other users.
--
Rich Woods
Technical Field Support Specialist, Oracle Corporation, USA
The above statements and opinions are my own and do not
necessarily represent those of Oracle Corporation.
Received on Tue Apr 01 1997 - 00:00:00 CST
