# US 2025/0094411 A1 · Adaptively overlapping the writing of redo log records

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2025/0094411 A1
- Document ID: US20250094411A1
- Status: Published application
- Kind: A1
- Application number: 18/598,122
- Filed: 2024-03-07
- Published: 2025-03-20
- Earliest claimed: 2023-09-15
- Assignees: Oracle International Corporation
- Applicants: Oracle International Corporation
- Inventors: Graham Ivey; Shih-Yu Huang; Yunrui Li; Shampa Chakravarty
- Web page: https://patentgrep.com/patent/US20250094411A1

## CPC

- G06F 16/2379: {Updates performed during online database operations; commit processing}
- G06F 16/2365: {Ensuring data consistency and integrity}
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## 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.

## Claims

### Claim 1

A method comprising:
assigning, by a log writer operating in a thin mode associated with one or more target sizes that are less than one or more target sizes associated with a thick mode, 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;
determining to operate the log writer in 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;
assigning, by the log writer operating in the thick mode, 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;
assigning, by the log writer operating in the thick mode, 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,
wherein the method is performed by one or more computing devices.

### Claim 2 (depends on 1)

The method of claim 1, wherein determining that the pipeline parameter is satisfied further comprises determining that a period of time elapsed since a most recent previous redo write meets or exceeds a timeout threshold.

### Claim 3 (depends on 1)

The method of claim 1, wherein determining that the pipeline parameter is satisfied further comprises determining that an amount of redo log records in the log buffer meets one of the one or more target sizes associated with the thin mode.

### Claim 4 (depends on 1)

The method of claim 1, further comprising determining that the plurality of log writer groups are unavailable to write the one or more second redo log records to the online redo log based at least in part on the highest busy group number being equal to a highest-numbered log writer group among the plurality of log writer groups.

### Claim 5 (depends on 1)

The method of claim 1, wherein the second log writer group is assigned, by the log writer operating in the thick mode, to write the one or more second redo log records from the log buffer to the online redo log in an instance in which the highest busy group number is within the core threshold.

### Claim 6 (depends on 1)

The method of claim 1, further comprising, in an instance in which the highest busy group number is within the core threshold, determining, by the log writer operating in the thick mode, that the amount of redo log records in the log buffer meets a decreased target size of the one or more target sizes associated with the thick mode.

### Claim 7 (depends on 1)

The method of claim 1, further comprising, in an instance in which the highest busy group number meets or exceeds the core threshold, determining, by the log writer operating in the thick mode, that the amount of redo log records in the log buffer meets an increased target size of the one or more target sizes associated with the thick mode.

### Claim 8 (depends on 1)

The method of claim 1, wherein plurality of log writer groups are ordinally numbered, and the highest busy group number comprises a numerical value corresponding to a highest-numbered log writer group among the plurality of log writer groups that is currently writing one or more redo log records to the online transaction log.

### Claim 9 (depends on 1)

The method of claim 1, further comprising determining to operate the log writer in the thin mode in response to determining that one or more respective target sizes of the one or more target sizes associated with the thick mode have equaled a minimum target size for a predefined number of redo writes.

### Claim 10 (depends on 1)

The method of claim 1, further comprising assigning, by the log writer operating in the thin mode, a fourth log writer group of the plurality of log writer groups to write one or more fourth redo log records to the online redo log in response to determining that the highest busy group number is less than or equal to one.

### Claim 11

One or more non-transitory storage media storing instructions which, when executed by one or more computing devices, cause:
assigning, by a log writer operating in a thin mode associated with one or more target sizes that are less than one or more target sizes associated with a thick mode, 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;
determining to operate the log writer in 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;
assigning, by the log writer operating in the thick mode, 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;
assigning, by the log writer operating in the thick mode, 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.

### Claim 12 (depends on 11)

The one or more non-transitory storage media of claim 11, wherein instructions causing determining that the pipeline parameter is satisfied, when executed by the one or more computing devices, further cause determining that a period of time elapsed since a most recent previous redo write meets or exceeds a timeout threshold.

### Claim 13 (depends on 11)

The one or more non-transitory storage media of claim 11, wherein the instructions causing determining that the pipeline parameter is satisfied, when executed by the one or more computing devices, further cause determining that an amount of redo log records in the log buffer meets one of the one or more target sizes associated with the thin mode.

### Claim 14 (depends on 11)

The one or more non-transitory storage media of claim 11, wherein the instructions, when executed by the one or more computing devices, further cause determining that the plurality of log writer groups are unavailable to write the one or more second redo log records to the online redo log based at least in part on the highest busy group number being equal to a highest-numbered log writer group among the plurality of log writer groups.

### Claim 15 (depends on 11)

The one or more non-transitory storage media of claim 11, wherein the second log writer group is assigned, by the log writer operating in the thick mode, to write the one or more second redo log records from the log buffer to the online redo log in an instance in which the highest busy group number is within the core threshold.

### Claim 16 (depends on 11)

The one or more non-transitory storage media of claim 11, wherein the instructions, when executed by the one or more computing devices, further cause, in an instance in which the highest busy group number is within the core threshold, determining, by the log writer operating in the thick mode, that the amount of redo log records in the log buffer meets a decreased target size of the one or more target sizes associated with the thick mode.

### Claim 17 (depends on 11)

The one or more non-transitory storage media of claim 11, wherein the instructions, when executed by the one or more computing devices, further cause, in an instance in which the highest busy group number meets or exceeds the core threshold, determining, by the log writer operating in the thick mode, that the amount of redo log records in the log buffer meets an increased target size of the one or more target sizes associated with the thick mode.

### Claim 18 (depends on 11)

The one or more non-transitory storage media of claim 11, wherein plurality of log writer groups are ordinally numbered, and the highest busy group number comprises a numerical value corresponding to a highest-numbered log writer group among the plurality of log writer groups that is currently writing one or more redo log records to the online transaction log.

### Claim 19 (depends on 11)

The one or more non-transitory storage media of claim 11, wherein the instructions, when executed by the one or more computing devices, further cause determining to operate the log writer in the thin mode in response to determining that one or more respective target sizes of the one or more target sizes associated with the thick mode have equaled a minimum target size for a predefined number of redo writes.

### Claim 20 (depends on 11)

The one or more non-transitory storage media of claim 11, wherein the instructions, when executed by the one or more computing devices, further cause comprising assigning, by the log writer operating in the thin mode, a fourth log writer group of the plurality of log writer groups to write one or more fourth redo log records to the online redo log in response to determining that the highest busy group number is less than or equal to one.
