277 views
in Tuning by ACE (20,920 points)

1 Answer

by ACE (20,920 points)

Larger - Better Performance.

Effects DBWR and checkpoint Behaviour.

FAST_START_MTTR_TARGET is set to limit recovery time, then need large redologs file size to avoid additional checkpoint. To find Optimal Size of redolog - OPTIMAL_LOGFILE_SIZE column under v$instance_recovery Table

select optimal_logfile_size from v$instance_recovery; # to find the optimal value for redologsize

Categories

...