What are the disadvantages of binary lock file in dbms?

1 answer

Answer

1017120

2026-04-10 04:40

+ Follow

Binary lock files in a database management system (DBMS) can lead to several disadvantages, including potential for deadlocks, where two transactions are waiting on each other to release locks. They can also result in reduced concurrency, as multiple transactions may be forced to wait for a single lock, leading to performance bottlenecks. Additionally, binary lock files may complicate recovery processes, as they can be less human-readable and harder to debug compared to other locking mechanisms. Lastly, their fixed structure may limit flexibility in managing varying transaction workloads.

ReportLike(0ShareFavorite

Copyright © 2026 eLLeNow.com All Rights Reserved.