Link to home
Start Free TrialLog in
Avatar of xoxomos
xoxomos

asked on

Redo log rotation frequency

I've read redo logs should rotate every 20 - 30 mins.   Is there a problem if the rotation is even more infrequent say 50 - 60 mins?
ASKER CERTIFIED SOLUTION
Avatar of gattu007
gattu007

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of gattu007
gattu007

The size of the redo log files can influence performance, because the behavior of
the database writer and archiver processes depend on the redo log sizes.
Generally, larger redo log files provide better performance, however
it must balanced out with the expected recovery time.Undersized log files
increase checkpoint activity and increase CPU usage.

Checkpoint frequency is affected by several factors, including log file size and
the setting of the FAST_START_MTTR_TARGET initialization parameter.
If the FAST_START_MTTR_TARGET parameter is set to limit the instance recovery time,
Oracle automatically tries to checkpoint as frequently as necessary.
Under this condition, the size of the log files should be large enough to avoid
additional checkpointing due to under sized log files.

You can find more info metalink        REDO LOGS SIZING ADVISORY
        Doc ID:       Note:274264.1
Avatar of xoxomos

ASKER

Thanks