Re: VLDB Redo Log Sizing Suggestions

Charles Davis wrote:

> Hi, all,
>
> I am looking for some expert guidance on re-sizing my SAP R/3 database re-do
> logs.
>
> I have 8 groups of mirrored logs, each log file is 200MB.
>
> I am archiving a log file every 5 to 8 minutes. This seems excessive.
>
> Suggestions?
>
> Oracle wants me to archive about every 20-30 minutes. Is a re-sizing as
> simple as tripling or quadrupling the re-do log sizes?
>
> Should I learn and use LogMiner to see what's going on and to influence the
> re-sizing?
>
> This is occurring in a 1TB SAP R/3 database, with the application code
> supplied by SAP, so I have little change to knowing or altering the souce
> code that may be causing excessive logging.
>
> I deeply appreciate any suggestions on this topic.
>
> Many Thanks, and Happy July 4th (USA Independence Day!!)
>
> Charles

Are there any problems with respect to performance or is this just busy work?

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)