公开(公告)号：US20250094411A1

公开(公告)日：2025-03-20

申请号：US18598122

申请日：2024-03-07

Applicant: Oracle International Corporation

Inventor： Graham Ivey ,  Shih-Yu Huang ,  Yunrui Li ,  Shampa Chakravarty

IPC: G06F16/23

Abstract: The present disclosure relates to adaptively overlapping redo writes. A log writer, while operating in a thin mode, may assign a first log writer group of a plurality of log writer groups to write one or more first redo log records to an online redo log in response to determining that a pipelining parameter is satisfied. The thin mode may be associated with one or more target sizes that are less than one or more target sizes associated with a thick mode. The log writer may determine to operate the thick mode based at least in part on at least a portion of the plurality of log writer groups being unavailable to write one or more second redo log records to the online redo log. The log writer, while operating in the thick mode, may assign a second log writer group of the plurality of log writer groups to write one or more second redo log records from the log buffer to the online redo log in response to determining that an amount of redo log records in the log buffer meets one of the one or more target sizes associated with the thick mode. The log writer, while operating in the thick mode, may assign a third log writer group of the plurality of log writer groups to write one or more second redo log records from the log buffer to the online redo log in response to determining that a highest busy group number meets or exceeds a core threshold.

公开(公告)号：US20250053299A1

公开(公告)日：2025-02-13

申请号：US18929241

申请日：2024-10-28

Applicant: Oracle International Corporation

Inventor： Yunrui Li ,  Graham Ivey ,  Shampa Chakravarty ,  Vsevolod Panteleenko

IPC: G06F3/06

Abstract: In an embodiment, before modifying a persistent ORL (ORL), a database management system (DBMS) persists redo for a transaction and acknowledges that the transaction is committed. Later, the redo is appended onto the ORL. The DBMS stores first redo for a first transaction into a first PRB and second redo for a second transaction into a second PRB. Later, both redo are appended onto an ORL. The DBMS stores redo of first transactions in volatile SRBs (SLBs) respectively of database sessions. That redo is stored in a volatile shared buffer that is shared by the database sessions. Redo of second transactions is stored in the volatile shared buffer, but not in the SLBs. During re-silvering and recovery, the DBMS retrieves redo from fast persistent storage and then appends the redo onto an ORL in slow persistent storage. After re-silvering, during recovery, the redo from the ORL is applied to a persistent database block.

公开(公告)号：US12164801B2

公开(公告)日：2024-12-10

申请号：US17880438

申请日：2022-08-03

Applicant: Oracle International Corporation

Inventor： Yunrui Li ,  Graham Ivey ,  Shampa Chakravarty ,  Vsevolod Panteleenko

IPC: G06F3/06

Abstract: In an embodiment, before modifying a persistent ORL (ORL), a database management system (DBMS) persists redo for a transaction and acknowledges that the transaction is committed. Later, the redo is appended onto the ORL. The DBMS stores first redo for a first transaction into a first PRB and second redo for a second transaction into a second PRB. Later, both redo are appended onto an ORL. The DBMS stores redo of first transactions in volatile SRBs (SLBs) respectively of database sessions. That redo is stored in a volatile shared buffer that is shared by the database sessions. Redo of second transactions is stored in the volatile shared buffer, but not in the SLBs. During re-silvering and recovery, the DBMS retrieves redo from fast persistent storage and then appends the redo onto an ORL in slow persistent storage. After re-silvering, during recovery, the redo from the ORL is applied to a persistent database block.

公开(公告)号：US20240045857A1

公开(公告)日：2024-02-08

申请号：US17880433

申请日：2022-08-03

Applicant: Oracle International Corporation

Inventor： Yunrui Li ,  Graham Ivey ,  Shampa Chakravarty ,  Vsevolod Panteleenko

IPC: G06F16/23 ,  G06F9/46

CPC classification number: G06F16/2379 ,  G06F16/2358 ,  G06F9/466

Abstract: In an embodiment, before modifying a persistent ORL (ORL), a database management system (DBMS) persists redo for a transaction and acknowledges that the transaction is committed. Later, the redo is appended onto the ORL. The DBMS stores first redo for a first transaction into a first PRB and second redo for a second transaction into a second PRB. Later, both redo are appended onto an ORL. The DBMS stores redo of first transactions in volatile SRBs (SLBs) respectively of database sessions. That redo is stored in a volatile shared buffer that is shared by the database sessions. Redo of second transactions is stored in the volatile shared buffer, but not in the SLBs. During re-silvering and recovery, the DBMS retrieves redo from fast persistent storage and then appends the redo onto an ORL in slow persistent storage. After re-silvering, during recovery, the redo from the ORL is applied to a persistent database block.

公开(公告)号：US12159032B2

公开(公告)日：2024-12-03

申请号：US17880446

申请日：2022-08-03

Applicant: Oracle International Corporation

Inventor： Yunrui Li ,  Graham Ivey ,  Shampa Chakravarty ,  Vsevolod Panteleenko

IPC: G06F3/06

Abstract: In an embodiment, before modifying a persistent ORL (ORL), a database management system (DBMS) persists redo for a transaction and acknowledges that the transaction is committed. Later, the redo is appended onto the ORL. The DBMS stores first redo for a first transaction into a first PRB and second redo for a second transaction into a second PRB. Later, both redo are appended onto an ORL. The DBMS stores redo of first transactions in volatile SRBs (SLBs) respectively of database sessions. That redo is stored in a volatile shared buffer that is shared by the database sessions. Redo of second transactions is stored in the volatile shared buffer, but not in the SLBs. During re-silvering and recovery, the DBMS retrieves redo from fast persistent storage and then appends the redo onto an ORL in slow persistent storage. After re-silvering, during recovery, the redo from the ORL is applied to a persistent database block.

公开(公告)号：US12086132B2

公开(公告)日：2024-09-10

申请号：US17880433

申请日：2022-08-03

Applicant: Oracle International Corporation

Inventor： Yunrui Li ,  Graham Ivey ,  Shampa Chakravarty ,  Vsevolod Panteleenko

IPC: G06F16/23 ,  G06F9/46

CPC classification number: G06F16/2379 ,  G06F9/466 ,  G06F16/2358

Abstract: In an embodiment, before modifying a persistent ORL (ORL), a database management system (DBMS) persists redo for a transaction and acknowledges that the transaction is committed. Later, the redo is appended onto the ORL. The DBMS stores first redo for a first transaction into a first PRB and second redo for a second transaction into a second PRB. Later, both redo are appended onto an ORL. The DBMS stores redo of first transactions in volatile SRBs (SLBs) respectively of database sessions. That redo is stored in a volatile shared buffer that is shared by the database sessions. Redo of second transactions is stored in the volatile shared buffer, but not in the SLBs. During re-silvering and recovery, the DBMS retrieves redo from fast persistent storage and then appends the redo onto an ORL in slow persistent storage. After re-silvering, during recovery, the redo from the ORL is applied to a persistent database block.

公开(公告)号：US20240045613A1

公开(公告)日：2024-02-08

申请号：US17880438

申请日：2022-08-03

Applicant: Oracle International Corporation

Inventor： Yunrui Li ,  Graham Ivey ,  Shampa Chakravarty ,  Vsevolod Panteleenko

IPC: G06F3/06

CPC classification number: G06F3/0656 ,  G06F3/0604 ,  G06F3/0679

Abstract: In an embodiment, before modifying a persistent ORL (ORL), a database management system (DBMS) persists redo for a transaction and acknowledges that the transaction is committed. Later, the redo is appended onto the ORL. The DBMS stores first redo for a first transaction into a first PRB and second redo for a second transaction into a second PRB. Later, both redo are appended onto an ORL. The DBMS stores redo of first transactions in volatile SRBs (SLBs) respectively of database sessions. That redo is stored in a volatile shared buffer that is shared by the database sessions. Redo of second transactions is stored in the volatile shared buffer, but not in the SLBs. During re-silvering and recovery, the DBMS retrieves redo from fast persistent storage and then appends the redo onto an ORL in slow persistent storage. After re-silvering, during recovery, the redo from the ORL is applied to a persistent database block.

公开(公告)号：US20240045591A1

公开(公告)日：2024-02-08

申请号：US17880446

申请日：2022-08-03

Applicant: Oracle International Corporation

Inventor： Yunrui Li ,  Graham Ivey ,  Shampa Chakravarty ,  Vsevolod Panteleenko

IPC: G06F3/06

CPC classification number: G06F3/061 ,  G06F3/0646 ,  G06F3/0683

Abstract: In an embodiment, before modifying a persistent ORL (ORL), a database management system (DBMS) persists redo for a transaction and acknowledges that the transaction is committed. Later, the redo is appended onto the ORL. The DBMS stores first redo for a first transaction into a first PRB and second redo for a second transaction into a second PRB. Later, both redo are appended onto an ORL. The DBMS stores redo of first transactions in volatile SRBs (SLBs) respectively of database sessions. That redo is stored in a volatile shared buffer that is shared by the database sessions. Redo of second transactions is stored in the volatile shared buffer, but not in the SLBs. During re-silvering and recovery, the DBMS retrieves redo from fast persistent storage and then appends the redo onto an ORL in slow persistent storage. After re-silvering, during recovery, the redo from the ORL is applied to a persistent database block.