Re: Do you ever really get row level locking?

Thomas J. Kyte wrote:
>

 <snip>
> No, this is wrong in the Oracle case as well. Oracle locks indexes at
> the lowest level. An index lock will lock a row, not all the entries
> on that block. There is no "adjacent key locking" or page locking
> involved here.
>
> An update of a single record will lock but one record and one record
> only.
>
<snip>

There is a case with a foreign key to non-indexed column that will lock a table. I suppose if I don't qualify that with a version I must be right. Isn't this the area where 7.3 reverses the case where a table lock is obtained.

Ed Bruce
Hughes Aircraft Company
bruce_at_ha.hac.com
ebruce_at_iquest.com Received on Mon Jun 10 1996 - 00:00:00 CEST