Very Computer

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

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