Re: Changing redo log file size

While it's true there isn't a solid answer for how big, you don't want a log switch every minute during normal use and you wouldn't want to switch only once per day. I like a log switch to happen every 20-40 minutes. This way, I don't have a whole day's worth of transactions sitting in just one logfile group and I'm not overburdening the system with log switches. Have a whole day's worth of transaction would make me nervous--the only time I have ever had trouble with recovery is when, for some reason, the current open redo log file got sick.

Just my 2 pennies worth.
Tomas

Andrew Rose <sydscan_at_ozemail.com.au> wrote in article <3405387a.476784_at_news>...
> >The size of my redo log files is 1M - with 2 redo log groups. We are
> >producing about 30M of redo per day.
> >
> >1) How can I resize the redo log files?
> Add new redo logs that are the size you want, then after making sure
> that the old ones aren't in use, drop them.
> (If the old ones are in use, use ALTER SYSTEM (DATABASE?) SWITCH
> LOGFILE - or whatever the correct syntax is)
> This way you're left with just the new ones.
>
> >2) What would be good values for redo log file size and number
> > of redo log groups?
> Still wrestling with this one. I've just switched to 3 groups of 5Mb
> each. There's not much clear advice on sizing that I've found so far.
>
Received on Fri Aug 29 1997 - 00:00:00 CDT