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