2.342 REDO_GENERATION_KBPS_MAX

REDO_GENERATION_KBPS_MAX specifies the maximum amount of redo, in kilobytes, that a PDB is allowed to generate each second.

Property Description

Parameter type

Integer

Default value

0

Modifiable

ALTER SYSTEM

Modifiable in a PDB

Yes

Range of values

0 to 2147483647

Basic

No

Oracle RAC

Different instances can use different values.

A large amount of redo generation can cause poor performance. If one PDB generates redo at a high rate, then it can affect the performance of other PDBs in the same CDB. You can use this parameter to limit the amount of redo generated by a specific PDB.

The default value of 0 indicates that there is no limit on the amount of redo that a PDB is allowed to generate.

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