Locking
From: Paul Harrison <cure_at_austin.rr.com>
Date: Thu, 17 Nov 2011 13:52:31 -0600
Message-ID: <000e01cca562$72299e90$567cdbb0$_at_austin.rr.com>
Hi All,
Date: Thu, 17 Nov 2011 13:52:31 -0600
Message-ID: <000e01cca562$72299e90$567cdbb0$_at_austin.rr.com>
Hi All,
Let's say I have 2 sessions open... session one updates a table and does not commit and can view the new updated data. session 2 is able to read the old data. How can session 2 read the old data if session 1 has an exclusive write lock on the table. Exclusive lock happens when updating a table?
Thanks,
Paul
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Nov 17 2011 - 13:52:31 CST