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