Time limited lock ownership

摘要

Described herein are techniques for time limited lock ownership. In one embodiment, in response to receiving a request for a lock on a shared resource, the lock is granted and a lock lease period associated with the lock is established. Then, in response to determining that the lock lease period has expired, one or more lock lease expiration procedures are performed. In many cases, the time limited lock ownership may prevent system hanging, timely detect system deadlocks, and/or improve overall performance of the database.

主权项

1. A computer-implemented method, comprising:
receiving a request for a lock on a shared resource; in response to receiving said request:
granting said lock on said shared resource to a lock holder, andestablishing a lock lease period associated with said lock; determining, based on one or more requests for a lock on said shared resource that are received from other processes executing in a system, that said lock lease period associated with said lock needs to be shortened; and in response to determining that said lock lease period associated with said lock needs to be shortened, shortening said lock lease period associated with said lock.