公开(公告)号：US09418129B2

公开(公告)日：2016-08-16

申请号：US13791607

申请日：2013-03-08

Applicant: Oracle International Corporation

Inventor： Chi Cao Minh ,  Vinay H. Srihari ,  Yunrui Li ,  Jonghyun Lee

IPC: G06F17/30

CPC classification number: G06F17/30575 ,  G06F17/30227 ,  G06F17/30368

Abstract: A method, system, and computer program product for adaptive high-performance database redo log synchronization. The method commences upon performing a write operation of a redo log entry, the write operation concluding with an indication of completion of the write operation of the redo log entry. Any number of committing processes may be waiting for the indication of completion, and upon indication of completion, then (using a first synchronization mode) the processes or proxy measures the waiting time as experienced by the committing processes (e.g., while waiting for the indication of completion of the write operation of the redo log entry). In some cases a second synchronization mode would introduce less latency than the first synchronization mode, so the system changes to a second synchronization mode. The system can also change mode when a predicted second mode waiting time is smaller than the measured waiting time.

Abstract translation: 一种用于自适应高性能数据库重做日志同步的方法，系统和计算机程序产品。 在执行重做日志条目的写入操作时，该方法开始，写入操作以与重做日志条目的写入操作的完成指示结束。 任何数量的提交过程可以等待完成的指示，并且在完成指示之后（使用第一同步模式），处理或代理测量由提交处理所经历的等待时间（例如，在等待指示时 完成重写日志条目的写入操作）。 在一些情况下，第二同步模式将引入比第一同步模式更少的延迟，因此系统改变为第二同步模式。 当预测的第二模式等待时间小于测量的等待时间时，系统也可以改变模式。

公开(公告)号：US20140279917A1

公开(公告)日：2014-09-18

申请号：US13831489

申请日：2013-03-14

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Chi Cao Minh ,  Yunrui Li ,  Jonghyun Lee

IPC: G06F17/30

CPC classification number: G06F16/13

Abstract: Techniques are provided for managing cached data objects in a mixed workload environment. In an embodiment, a system, log data is stored in one or more buffers. In response to receiving a request to perform a logical write, a first process writes a first portion of the log data to a log file in persistent storage. While the first portion of the log data is being written to the log file, a second process writes a second portion of the log data in the one or more buffers to the log file in persistent storage. In another embodiment, a request to perform a second logical write may be received before the first logical write completes. While the first log data is being written to the log file, one or more processes write second log data for the second logical write to the log file.

Abstract translation: 提供了在混合工作负载环境中管理缓存数据对象的技术。 在一个实施例中，系统，日志数据被存储在一个或多个缓冲器中。 响应于接收到执行逻辑写入的请求，第一进程将日志数据的第一部分写入持久存储器中的日志文件。 当日志数据的第一部分被写入日志文件时，第二个进程将一个或多个缓冲区中的日志数据的第二部分写入持久存储器中的日志文件。 在另一个实施例中，可以在第一逻辑写完成之前接收执行第二逻辑写入的请求。 当第一个日志数据被写入日志文件时，一个或多个进程将第二个逻辑写入的第二个日志数据写入日志文件。

公开(公告)号：US20140164331A1

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

申请号：US14135202

申请日：2013-12-19

Applicant: Oracle International Corporation

Inventor： Yunrui Li ,  Chi Cao Minh ,  Kumar Rajamani ,  Jaebock Lee ,  Sanket Jain ,  Giridhar Ravipati ,  Jonghyun Lee

IPC: G06F11/14 ,  G06F17/30

CPC classification number: G06F3/0619 ,  G06F3/065 ,  G06F3/067 ,  G06F11/1448 ,  G06F11/1469 ,  G06F11/1471 ,  G06F12/084 ,  G06F13/1663 ,  G06F17/30289 ,  G06F17/30292 ,  G06F17/3048 ,  G06F17/30557 ,  G06F17/30566 ,  G06F17/30595 ,  G06F17/30867 ,  G06F21/6218 ,  G06F2201/80 ,  G06F2201/835 ,  G06F2212/60 ,  G06F2212/62

Abstract: A container database stores redo records and logical timestamps for multiple pluggable databases. When it is detected that a first read-write instance of the pluggable database is opened and no other read-write instances of the pluggable database are open, offline range data associated with the pluggable database is updated. When it is detected that a second read-write instance of the pluggable database is closed, and the second read-write instance is the last open read-write instance, the offline range data associated with the pluggable database is updated. The pluggable database is restored to a logical timestamp associated with a restore request based on the offline range data.

Abstract translation: 容器数据库存储多个可插拔数据库的重做记录和逻辑时间戳。 当检测到可插拔数据库的第一个读写实例被打开，并且没有可插拔数据库的其他读写实例被打开时，与可插拔数据库关联的脱机范围数据被更新。 当检测到可插拔数据库的第二读写实例被关闭，并且第二读写实例是最后打开的读写实例时，更新与可插拔数据库相关联的脱机范围数据。 基于离线范围数据，可插拔数据库恢复到与恢复请求相关联的逻辑时间戳。