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!

Redo logs size

RadekFeb 19 2010 — edited Feb 23 2010
Hi,

I'm dealing with 15TB db. I'm wondering what are the optimal redo log files size? For now I have them setup to 1.5GB.
Sometimes there are over 20 log switches within an hour.This is pretty busy db.
I'm worrying that this is having performance. This is production environment.
Should I leave them as they are or increase them to 2.5GB ?

We don't want to set MTTR for the db, as startup time is not very important for us.

What would you suggest?
Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 23 2010
Added on Feb 19 2010
#general-database-discussions
13 comments
9,575 views