Redo Log recommended size
PinelaNov 7 2011 — edited Aug 27 2012Greetings All,
For some time I've questioned myself what would be the correct redologsize for a given database.
I found the note
10g New Feature: REDO LOGS SIZING ADVISORY [ID 274264.1]
that says:
"+As rule of thumb switching logs at most once every fifteen minutes.+"
Well, I came across a DB with about 3 logswitches/minute (OEL 4.6, 10gR2 RAC environment).
Do you agree that this number is WAY over what it should be? What are your redolog sizes?
The note also mentioned using the v$instance_recovery view to advise on the redolog size, which takes into account the MTTR.
Thank you.
BR,
Pinela.
Edited by: Pinela on Nov 7, 2011 2:42 PM