Still the case that rolling back to savepoint does not restart blocked sessions?

  • From: "McPeak, Matt" <vxsmimmcp@xxxxxxxxxx>
  • To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 29 May 2014 18:02:24 +0000

If transaction A is waiting on a lock held by transaction B and transaction B 
rolls back to a savepoint (releasing the lock), transaction A remains blocked 
until transaction B ends completely (with either a full rollback or a commit).

Does anyone know if this is still the case in 12c?  I really hate this behavior.

Thanks,
Matt




Other related posts: