Oracle International Corporation

Benedicto Garin

Mahesh Baburao Girkar

Juan R Loaiza

Joydip Kundu

Nitin Karkhanis

Steve Lee

Jiangbin Luo

Hongjie Yang

Michael Harvey

Steven McGee

Robert McGuirk

Qinqin Wang

Disclosed are methods and apparatuses to provide a redo repeater that allows for no data loss protection without the performance impact to the primary database even when a significant geographical distance separates the primary and standby databases. The Repeater is a lightweight entity that receives redo from the primary database with the purpose of redistributing that redo throughout the primary/standby system configuration. The Repeater able to extend no data loss protection and switchover functionality to terminal standby databases even though the primary database does not need to have a direct connection with those destinations.

Method and system for implementing a redo repeater

A method and apparatus for applying changes to a standby database in real-time. According to one aspect, a change is applied to data contained in a standby database. The standby database functions as a replica of a primary database. The primary database has a current online redo log file to which a particular redo block was written. According to one aspect, prior to the archiving of the current online redo log file, the particular redo block is received at a process associated with the standby database. A change indicated by the particular redo block is applied to the data contained in the standby database.

Real-time apply mechanism in standby database environments

The present invention is a paging scheme that provides improved performance for various applications. In one embodiment of the present invention, a method of paging data comprises the steps of storing a plurality of pages of data in a main memory, determining that paging must occur, and paging out a page of data from the main memory based on the memory pressure of the page of data. The paging out step may comprise the steps of determining an amount of time a page is or will be in memory for each of the plurality of pages of data in the main memory and determining a memory pressure for each of the plurality of pages of data in the main memory.

Memory paging based on memory pressure and probability of use of pages

Growing community of inventors

Hollis, NH, United States of America

Benedicto Garin