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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks
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