公开(公告)号：US09075650B2

公开(公告)日：2015-07-07

申请号：US13867427

申请日：2013-04-22

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Michael Zoll ,  Angelo Pruscino ,  Wilson Chan

IPC: G06F9/46 ,  G06F9/48 ,  G06F9/50 ,  G06F9/52

CPC classification number: G06F9/46 ,  G06F9/4818 ,  G06F9/5038 ,  G06F9/524

Abstract: Systems, methods, and other embodiments associated with avoiding resource blockages and hang states are described. One example computer-implemented method for a computing system includes determining that a first process is waiting for a resource and is in a blocked state. The resource that the first process is waiting for is identified. A blocking process that is holding the resource is then identified. A priority of the blocking process is compared with a priority the first process. If the priority of the blocking process is lower than the priority of the first process, the priority of the blocking process is increased. In this manner the blocking process can be scheduled for execution sooner and thus release the resource.

Abstract translation: 描述了与避免资源阻塞和挂起状态相关联的系统，方法和其他实施例。 用于计算系统的一个示例性计算机实现的方法包括确定第一进程正在等待资源并处于阻塞状态。 确定第一个进程正在等待的资源。 然后识别持有资源的阻塞进程。 阻塞进程的优先级与第一进程的优先级进行比较。 如果阻塞进程的优先级低于第一个进程的优先级，则阻塞进程的优先级增加。 以这种方式，可以更快地将阻塞进程安排进行执行，从而释放资源。

公开(公告)号：US20170220428A1

公开(公告)日：2017-08-03

申请号：US15014969

申请日：2016-02-03

Applicant: Oracle International Corporation

Inventor： Yunrui Li ,  Chi Cao Minh ,  Wilson Chan ,  Tolga Yurek ,  Ping-Hsiu Hsieh

IPC: G06F11/14 ,  G06F17/30

CPC classification number: G06F17/30557 ,  G06F17/30

Abstract: Embodiment provide that each pluggable database (PDB) in a container database is associated with a distinct distributed lock manager (DLM) domain. Thus, in order to access a PDB, a database server instance joins the DLM domain for the PDB. To perform actions on the PDB, the instance secures locks that belong to the DLM domain for the particular PDB. As such, buffers storing data for the PDB may be managed separately from buffers storing data for other PDBs using the PDB-specific DLM domains. An instance forcefully closing a particular PDB marks the DLM domain of the PDB as invalid, which allows detection of the forceful closure by a recovery instance. Detection of an invalid DLM domain by an instance causes the instance to automatically recover the PDB by accessing pertinent ranges of redo logs and replaying changes made to data blocks for the PDB indicated in the logs.

公开(公告)号：US09928147B2

公开(公告)日：2018-03-27

申请号：US15014969

申请日：2016-02-03

Applicant: Oracle International Corporation

Inventor： Yunrui Li ,  Chi Cao Minh ,  Wilson Chan ,  Tolga Yurek ,  Ping-Hsiu Hsieh

IPC: G06F11/14 ,  G06F17/30

CPC classification number: G06F17/30557 ,  G06F17/30

Abstract: Embodiment provide that each pluggable database (PDB) in a container database is associated with a distinct distributed lock manager (DLM) domain. Thus, in order to access a PDB, a database server instance joins the DLM domain for the PDB. To perform actions on the PDB, the instance secures locks that belong to the DLM domain for the particular PDB. As such, buffers storing data for the PDB may be managed separately from buffers storing data for other PDBs using the PDB-specific DLM domains. An instance forcefully closing a particular PDB marks the DLM domain of the PDB as invalid, which allows detection of the forceful closure by a recovery instance. Detection of an invalid DLM domain by an instance causes the instance to automatically recover the PDB by accessing pertinent ranges of redo logs and replaying changes made to data blocks for the PDB indicated in the logs.

公开(公告)号：US08990179B2

公开(公告)日：2015-03-24

申请号：US13721614

申请日：2012-12-20

Applicant: Oracle International Corporation

Inventor： Wilson Chan ,  Angelo Pruscino ,  Michael Zoll

IPC: G06F17/30 ,  G06F9/52

CPC classification number: G06F9/52 ,  G06F17/30362

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.

Abstract translation: 这里描述的是用于限时锁定所有权的技术。 在一个实施例中，响应于接收到对共享资源的锁定的请求，该锁被授予并且与该锁相关联的锁租约期间被建立。 然后，响应于确定锁租约期已经过期，执行一个或多个锁租约期过程。 在许多情况下，限时锁定所有权可能会阻止系统挂起，及时检测系统死锁，和/或提高数据库的整体性能。

公开(公告)号：US20130111089A1

公开(公告)日：2013-05-02

申请号：US13721614

申请日：2012-12-20

Applicant: Oracle International Corporation

Inventor： Wilson Chan ,  Angelo Pruscino ,  Michael Zoll

IPC: G06F9/52

CPC classification number: G06F9/52 ,  G06F17/30362

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.

Abstract translation: 这里描述的是用于限时锁定所有权的技术。 在一个实施例中，响应于接收到对共享资源的锁定的请求，该锁被授予并且与该锁相关联的锁租约期间被建立。 然后，响应于确定锁租约期已经过期，执行一个或多个锁租约期过程。 在许多情况下，限时锁定所有权可能会阻止系统挂起，及时检测系统死锁，和/或提高数据库的整体性能。