Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Geraldo.

Asked: April 18, 2019 - 11:55 am UTC

Last updated: April 30, 2019 - 2:32 am UTC

Version: 18.4

Viewed 1000+ times

You Asked

Hello, Ask Tom Team.

What is the best practice: small redo log groups or have a few but with a bigger size?

Thanks in advanced.

Regards,

and Connor said...

Generally I like my size redo logs so that they switch about every 30-60mins.

There are some overheads to a switch (these used to be large, but with each release its gets better) so I'm not fan of really really frequent switches.


Rating

  (2 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Follow Up

Geraldo Peralta, April 29, 2019 - 3:51 pm UTC

Hmm. Ok. So you size your redo logs to switch between 30 and 60 minutes (because obviously it depends on the app).

1. You view how frequently they switch in the alert log and then increase or decrease the size?

2. How many groups, how many member per group?


Connor McDonald
April 30, 2019 - 2:32 am UTC

1. You view how frequently they switch in the alert log and then increase or decrease the size?


Yes, or look at v$log_history

2. How many groups, how many member per group?

Opinions vary. I typically go with enough groups so that I'll never got stuck wrapping around and having to wait for a group to be archived.

Some people prefer 2 members per group because they worry about redo log corruption. I've generally gone with 1 per group and never had an issue.


Review

Geraldo Peralta, May 01, 2019 - 6:04 pm UTC

Good.

Thanks. :)
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database