公开(公告)号：US20210271663A1

公开(公告)日：2021-09-02

申请号：US17202024

申请日：2021-03-15

Applicant: Oracle International Corporation

Inventor： Sachin Vijaykumar SONAWANE ,  Mahesh BABURAO GIRKAR ,  Yunrui LI ,  Thomas BABY ,  Vivekanandhan RAJA

IPC: G06F16/23 ,  G06F16/27

Abstract: A database session in an active standby server on which an active standby database resides receives a DML statement. The session is suspended while the statement is redirected over a database link to a primary database on which the statement is executed. Information associated with execution of the statement is communicated to the session in the active standby server. Redo records describing changes to the contents of the primary database are applied to the active standby database and control is returned to the session. Prior to commitment of a transaction including the statement, a query directed to data to which the statement was directed is received at the active standby server from a client and executed on the active standby database absent use of a database link based on whether information associated with a database session associated with the client matches the information associated with execution of the statement.

公开(公告)号：US20190102421A1

公开(公告)日：2019-04-04

申请号：US15885281

申请日：2018-01-31

Applicant: Oracle International Corporation

Inventor： Sachin Vijaykumar SONAWANE ,  Mahesh Baburao GIRKAR ,  Yunrui LI ,  Thomas Baby ,  Vivekanandhan Raja

IPC: G06F17/30

Abstract: A database session in an active standby server on which an active standby database resides receives a DML statement. The session is suspended while the statement is redirected over a database link to a primary database on which the statement is executed. Information associated with execution of the statement is communicated to the session in the active standby server. Redo records describing changes to the contents of the primary database are applied to the active standby database and control is returned to the session. Prior to commitment of a transaction including the statement, a query directed to data to which the statement was directed is received at the active standby server from a client and executed on the active standby database absent use of a database link based on whether information associated with a database session associated with the client matches the information associated with execution of the statement.