Time limited lock ownership

Patent metadata

Field	Value
Publication number	US-8990179-B2
Application number	US-201213721614-A
Country	US
Kind code	B2
Filing date	Dec 20, 2012
Priority date	Dec 19, 2008
Publication date	Mar 24, 2015
Grant date	Mar 24, 2015

Abstract

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.

First claim

What is claimed is:

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, and
establishing 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…

Assignees

• Oracle Int Corp

Inventors

• Chan Wilson
• Pruscino Angelo
• Zoll Michael

Classifications

• G06F9/52 Primary

  Physics · mapped topic

• G06F17/30362

  Physics · mapped topic

• G06F16/2343 Primary

  Physics · mapped topic