Leaf node scans
Latches do not support deadlock detection or avoidance.The only way we can deal with this problem is through coding discipline.
The leaf node sibling latch acquisition protocol must support a "no-wait" mode.
The DBMS's data structures must cope with failed latch acquisitions.
Last updated