2.217 LOG_REDO_PRIORITIZATION

Use LOG_REDO_PRIORITIZATION to enable or disable log buffer space redo prioritization.

Property Description

Parameter type

Boolean

Default value

FALSE

Modifiable

ALTER SYSTEM

Modifiable in a PDB

No

Range of values

TRUE | FALSE

Basic

No

Oracle RAC

Different instances can use different values.

Log buffer space redo prioritization is a feature that prioritizes redo generation for sessions, based on their characteristics, such as batch sessions versus OLTP sessions. When log buffer space redo prioritization is enabled, it continuously monitors redo log buffer utilization and triggers redo prioritization when free redo log buffer space falls below an internal threshold.

Values:

  • TRUE - Enable log buffer space redo prioritization

  • FALSE - Disable log buffer space redo prioritization (the default)

Note:

This parameter is available starting with Oracle AI Database 26ai, Release Update 23.26.3.

See Also:

Oracle AI Database Administrator’s Guide for more information about this parameter