Why do you ask this? Logically those four rows will be exclusively locked by the transaction. I wonder why whether Oracle 'creates' 1 or 4 'locks' (whatever 'creating a lock' may mean), is of any relevance... On Sat, Mar 10, 2012 at 5:56 PM, Paul Harrison <cure@xxxxxxxxxxxxx> wrote: > Hello, > > > I have a table with four rows. I issue the sql statement: update table set > name = 'test'; this will update 4 rows. Will Oracle create 4 locks one for > each row or 1 lock for the 4 rows? > > > > Thanks, > > Paul > > > > -- > //www.freelists.org/webpage/oracle-l > > > -- Toon Koppelaars RuleGen BV Toon.Koppelaars@xxxxxxxxxxx www.RuleGen.com TheHelsinkiDeclaration.blogspot.com (co)Author: "Applied Mathematics for Database Professionals" www.rulegen.com/am4dp-backcover-text -- //www.freelists.org/webpage/oracle-l