Re: table level locks, row level locks, column level locks?

From: Howard J. Rogers <howardjr_at_www.com>
Date: Tue, 6 Nov 2001 05:27:59 +1100
Message-ID: <3be6da1d$0$3444$afc38c87@news.optusnet.com.au>

No. Oracle uses row locks, not column locks. As true in 9i as 7.

Regards
HJR

--

Oracle Resources : http://www.hjrdba.com
=============================


"NetComrade" <andreyNSPAM_at_bookexchange.net> wrote in message
news:3be6d81e.505702371_at_news.globix.com...


> Whenever I update a table

> update table A set col1='1' where a.id between 1 and 10000

>

> all rows lock  for updates that fall into that range,

> so while this update is running if another update comes in

> update table A set col2='2' where a.id between 100 and 150

>

> it cannot complete until the first update completes and commits...

> but the queries are updating difference columns.. is there are any new

> features that allow you to differentiate those queries and let them

> run concurently?

>

> Thanx.

> .......

> We use Oracle 8.1.6-8.1.7 on Solaris 2.6, 2.7 boxes

> Andrey Dmitriev eFax: (978) 383-5892  Daytime: (917) 750-3630

> AOL: NetComrade ICQ: 11340726 remove NSPAM to email

Received on Mon Nov 05 2001 - 12:27:59 CST