Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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
#general-database-discussions, #rac
15 comments
14,913 views