公开(公告)号：US09514160B2

公开(公告)日：2016-12-06

申请号：US13794112

申请日：2013-03-11

Applicant: Oracle International Corporation

Inventor： Shanshan Song ,  Yunrui Li ,  Tolga Yurek ,  Mahesh Girkar ,  Neil MacNaughton

IPC: G06F17/30

CPC classification number: G06F17/30289 ,  G06F17/30575 ,  G06F17/30581

Abstract: A method, system, and computer program product. The method for non-intrusive redeployment of a standby database facility comprises configuring a database system having a shared lock manager process to synchronize two or more concurrent access instances, then granting lock requests for access to a cache of database blocks. At some moment in time, the shared lock manager process may fail, and a monitor process detects the failure or other stoppage of the shared lock manager process. A new shared lock manager process and other processes are started, at least one of which serves for identifying the database blocks in the cache that have not yet been written to the database. The identified blocks are formed into a recovery set of redo operations. During this time, incoming requests for access to the cache of database blocks are briefly blocked, at least until the recovery set of redo operations has been formed.

Abstract translation: 一种方法，系统和计算机程序产品。 用于非侵入式重新部署备用数据库设施的方法包括配置具有共享锁管理器进程的数据库系统以同步两个或多个并发访问实例，然后授予对数据库块的高速缓存的锁定请求。 在某个时刻，共享锁管理器进程可能会失败，并且监视进程检测到共享锁管理器进程的故障或其他停止。 启动新的共享锁管理器进程和其他进程，其中至少一个用于识别高速缓存中尚未写入数据库的数据库块。 所识别的块被形成恢复一组重做操作。 在此期间，暂时阻止访问数据库块的缓存的传入请求，至少在恢复组重做操作已经形成之前。

公开(公告)号：US10216781B2

公开(公告)日：2019-02-26

申请号：US14983496

申请日：2015-12-29

Applicant: Oracle International Corporation

Inventor： Sanket Hase ,  Neil MacNaughton ,  Vivekanandhan Raja ,  Atrayee Mullick ,  Vineet Marwah ,  Amit Ganesh

IPC: G06F12/14 ,  G06F17/30 ,  G06F12/084 ,  G06F12/0868 ,  G06F12/0875

Abstract: Techniques are described for maintaining coherency of a portion of a database object populated in the volatile memories of multiple nodes in a database cluster. The techniques involve maintaining a local invalidation bitmap for chunks of data stored in memory in each particular node in the cluster by tracking locks granted by a lock manager. During a pre-loading operation, each given node requests a set of shared locks associated with the chunks of data to be store in the given node's memory. When a request to release one of these shared locks occurs, the in-memory copy of those data items may be invalidated in the node releasing its shared lock.

公开(公告)号：US20160350363A1

公开(公告)日：2016-12-01

申请号：US14983481

申请日：2015-12-29

Applicant: Oracle International Corporation

Inventor： Vivekanandhan Raja ,  Atrayee Mullick ,  Sanket Hase ,  Sukhada Pendse ,  Amit Ganesh ,  Vineet Marwah ,  Neil MacNaughton

IPC: G06F17/30

CPC classification number: G06F17/30377 ,  G06F3/065 ,  G06F17/30353 ,  G06F17/30362 ,  G06F17/30371

Abstract: Techniques are herein described for loading a portion of a database object into volatile memory without blocking database manipulation language transactions. The techniques involve invalidating data items loaded from blocks affected by a transaction, referred to as a straddling transaction that started before the load time and committed after the load time. Identifying these straddling transactions involves reviewing one or more transaction lists associated with the set of data items loaded in memory. The transaction list may be read in reverse temporal order of commit to identify a transaction meeting the criteria of starting before the load start, not committing before the load time, and affecting a data item loaded in memory.

Abstract translation: 这里描述了将数据库对象的一部分加载到易失性存储器中而不阻止数据库操作语言事务的技术。 这些技术涉及使由事务影响的块加载的数据项无效，称为在加载时间之前启动并在加载时间后提交的跨接事务。 识别这些跨越事务涉及查看与加载在存储器中的数据项集相关联的一个或多个事务列表。 交易列表可以以提交的反时间顺序读取，以识别满足在加载开始之前开始的准则的事务，而不是在加载时间之前提交，并影响加载到存储器中的数据项。

公开(公告)号：US20140095802A1

公开(公告)日：2014-04-03

申请号：US13831462

申请日：2013-03-14

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Adam Y. Lee ,  J. William Lee ,  Dmitry Mikhailovich Potapov ,  Neil MacNaughton ,  Vipin Gokhale ,  Bharat Chandra Baddepudi ,  David Vengerov

IPC: G06F12/12

CPC classification number: G06F12/128 ,  G06F12/126 ,  G06F16/24561

Abstract: Techniques are provided for managing cached data objects in a mixed workload environment. In an embodiment, a database system receives request to access a target data object. The database system determines whether the request to access the target data object is associated with a first type of workload or a second type of workload. In response to determining that the request is associated with the first type of workload, the target data object replaces a least recently used data object in a cache. In response to determining that the request is associated with the second type of workload, the target data object is cached based on an associated access-level value.

Abstract translation: 提供了在混合工作负载环境中管理缓存数据对象的技术。 在一个实施例中，数据库系统接收访问目标数据对象的请求。 数据库系统确定访问目标数据对象的请求是否与第一类工作负载或第二类工作负载相关联。 响应于确定该请求与第一类型的工作负载相关联，目标数据对象将替换高速缓存中最近最少使用的数据对象。 响应于确定该请求与第二类型的工作负载相关联，基于相关联的访问级别值来缓存目标数据对象。

公开(公告)号：US10339069B2

公开(公告)日：2019-07-02

申请号：US13831462

申请日：2013-03-14

Applicant: Oracle International Corporation

Inventor： Adam Y. Lee ,  J. William Lee ,  Dmitry Mikhailovich Potapov ,  Neil MacNaughton ,  Vipin Gokhale ,  Bharat Chandra Baddepudi ,  David Vengerov

IPC: G06F12/12 ,  G06F12/128 ,  G06F12/126 ,  G06F16/2455

Abstract: Techniques are provided for managing cached data objects in a mixed workload environment. In an embodiment, a database system receives request to access a target data object. The database system determines whether the request to access the target data object is associated with a first type of workload or a second type of workload. In response to determining that the request is associated with the first type of workload, the target data object replaces a least recently used data object in a cache. In response to determining that the request is associated with the second type of workload, the target data object is cached based on an associated access-level value.

公开(公告)号：US10067974B2

公开(公告)日：2018-09-04

申请号：US14983481

申请日：2015-12-29

Applicant: Oracle International Corporation

Inventor： Vivekanandhan Raja ,  Atrayee Mullick ,  Sanket Hase ,  Sukhada Pendse ,  Amit Ganesh ,  Vineet Marwah ,  Neil MacNaughton

IPC: G06F17/30 ,  G06F3/06

Abstract: Techniques are herein described for loading a portion of a database object into volatile memory without blocking database manipulation language transactions. The techniques involve invalidating data items loaded from blocks affected by a transaction, referred to as a straddling transaction that started before the load time and committed after the load time. Identifying these straddling transactions involves reviewing one or more transaction lists associated with the set of data items loaded in memory. The transaction list may be read in reverse temporal order of commit to identify a transaction meeting the criteria of starting before the load start, not committing before the load time, and affecting a data item loaded in memory.