tag:blogger.com,1999:blog-27482298.post1826760323231630883..comments2024-02-25T22:29:18.572+00:00Comments on Andrew's Oracle Blog: Rollback to Savepoint Does Not Release LocksUnknownnoreply@blogger.comBlogger2125tag:blogger.com,1999:blog-27482298.post-89371231801686962212014-11-18T01:58:46.197+00:002014-11-18T01:58:46.197+00:00Good to know. Reproduced in 11.2.0.3.
It's tr...Good to know. Reproduced in 11.2.0.3.<br /><br />It's true, the row lock is released (allowing Donald to update the row), but Oracle blocks Fred on John's session (because dba_waiters is not fine-grained enough to pick up which row locks were released by the rollback to savepoint).<br /><br />Of course, if John were to do a full rollback, the session is unlocked immediately.Jeffrey Kemphttp://jeffkemponoracle.comnoreply@blogger.comtag:blogger.com,1999:blog-27482298.post-90026154987101535792014-11-14T09:38:50.129+00:002014-11-14T09:38:50.129+00:00You don't see the second session 'unblock&...You don't see the second session 'unblock', that is because the second session is blocked on the first session - NOT on the row the first session locked, but on the first session itself.Anonymousnoreply@blogger.com