Re: Lock
Date: Mon, 12 Mar 2012 12:35:42 -0000
Message-ID: <5C01B545606748CFA1E0D27DFAD01EA9_at_Primary>
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_at_austin.rr.com> To: <oracle-l_at_freelists.org> 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
--
http://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
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Mar 12 2012 - 07:35:42 CDT