Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle block locking?
No locks are at a row level and never escalate to the block or to the table
level.
Others should be able to read the row (as it was) just not update it.
Jim
"Frank Bucher" <frankbucher_at_gmx.de> wrote in message
news:f742146.0202210638.3a4d9d25_at_posting.google.com...
> Hi all,
> we're running 8.1.7.2 server on an AIX machine and have 8.1.5 clients
> on NT machines. The discussion that appears is, that if oracle does
> some kind of row locking. We have one table 'customer' (which is a
> parent table to several other ones). On this table a transaction holds
> a lock (row exclusive), because a client worked with a customer
> (insert/update). Could it be that oracle locks other customer as well
> for an insert or an update? It seems that other the clients couldn't
> work with other customers as well. Therefore it seems as if oracle
> tries to lock a whole block?! Does this behaviour depend on the kind
> of activity (insert or update)? How does an insert on a table affect
> locks at all, if it has no foreign keys?
>
> Any help appreciated.
>
> TIA
> Frank.
>
> PS: Could you please mail the answer as well to frankbucher_at_gmx.de
Received on Thu Feb 21 2002 - 09:30:10 CST