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 3 years ago
