Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Redo Log recommended size

PinelaNov 7 2011 — edited Aug 27 2012
Greetings 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
This post has been answered by Aman.... on Nov 9 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 24 2012
Added on Nov 7 2011
15 comments
15,638 views