If I run an insert Sql statement to a table,which level lock that the
database will give to the statement,table-level or row-level?how about
update statement and delete statement.
Andrew J. Kelly SQL MVP
> If I run an insert Sql statement to a table,which level lock that the
> database will give to the statement,table-level or row-level?how about
> update statement and delete statement.
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
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