Ambiguous question, really. Each row will have its lock byte set. Each table block involved will have one ITL entry used to identify the locking transaction There will be a TM lock (mode 3, id1 = table's object_id) displayed in v$lock to show that there is an active transaction modifying the table. There will be a TX lock displayed in v$lock which will report the transaction table entry from the undo segment header being used by the transaction Regards Jonathan Lewis http://jonathanlewis.wordpress.com Oracle Core (Apress 2011) http://www.apress.com/9781430239543 ----- Original Message ----- From: "Paul Harrison" <cure@xxxxxxxxxxxxx> To: <oracle-l@xxxxxxxxxxxxx> Sent: Saturday, March 10, 2012 4:56 PM Subject: Lock 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 ----- No virus found in this message. Checked by AVG - www.avg.com Version: 2012.0.1913 / Virus Database: 2114/4861 - Release Date: 03/09/12 -- //www.freelists.org/webpage/oracle-l