Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Redo Log Size
1M .... large ... ??? you mean small !
4 logswitches in less than one minute - why don't you make'm 30MB or
something ... should give
you a logswitch every 10 minutes or so ... still pretty high but better ...
We have a 800GB DB with 12 loggroups and each member is 256MB so you
shouldn't loose your
sleep if you think 2M is too large ... and oh ... as always tune your
checkpoints.
Who installed your DB - if I were you I would check if I didn't have a 100k logbuffer and an 8Mb buffercache ... smells like a default install ...
"Bryce Moulton" <brycemoulton_at_eaton.com> wrote in message
news:9mgl8q$eek2_at_interserv.etn.com...
> I have a 16G db that houses BLOB's anywhere from 0 to 2M.
> I have 4 redo log groups with each member being 1M in size.
> 1M seems to be pretty large, but I'm getting errors in my alert log
because
> arch isn't finished archiving when the log group needs to be used again.
> Sometimes in the alert log I can see where all 4 of the log groups have
been
> gone through in less than 1 minute.
>
> I believe all indications point to increasing size or # of groups, but I'm
> not sure if Oracle recommends a max size for redo log files.
>
> Should I increase the size to 2M, or perhaps the # of groups to 5 or 6
> groups??
>
> I would greatly appreciate help. I can't seem to find much documentation
on
> this.
>
> Thank you, Bryce Moulton
>
>
Received on Tue Aug 28 2001 - 13:49:47 CDT