Hi Team,
Need some understanding regarding recovery conflict due to buffer pin.
We see "User was holding shared buffer pin for too long" .
I understand that this can be due to holding lock to update content of a db
block or page.
1> Is the lock held on a buffer page or page at disk level?
2> Is there any serialization present to maintain the locking mechanism?
Thanks