table level locks, row level locks, column level locks?

table level locks, row level locks, column level locks?

Post by NetComra » Wed, 07 Nov 2001 03:23:07



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

 
 
 

table level locks, row level locks, column level locks?

Post by Howard J. Roger » Wed, 07 Nov 2001 03:27:59


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

Regards
HJR
--

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


Quote:> 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