Block level contention

Posted by satish on
URL: http://erman-arslan-s-oracle-forum.114.s1.nabble.com/Block-level-contention-tp7249.html

Dear Erman,

Need your expertise

Lets say user A want to update a record in some table.The block is loaded into memory and a latch is acquired in exclusive mode and the corresponding record is updated.

Before user A releases the latch,If some other user B wants to update a different record in the same block,will he be able to update it OR does he needs to wait till user A completes his updation?

Also,will multiple selects on the same block creates multiple versions of that block in dbbuffer cache?

Thank you