Re: Archive mode

"Howard J. Rogers" <howardjr_at_www.com> wrote in message news:3a033949_at_news.iprimus.com.au...
>
> So the solution becomes obvious: adding more redo log groups will help
> prevent system hangs.
>
> Making the log files almost certainly won't help at all -yes, it takes
> longer to fill up a bigger log, and hence the switch will be delayed. But
> once it *does* switch, ARCH has more work to do, copying a bigger file. In
> the general case, the two are likely to cancel each other out, and achieve
> precisely nothing.
>

precisely. increasing the size of the redo log files, however, CAN potentially reduce the frequency of log switches.

> Regards
> HJR
>
Received on Sun Nov 05 2000 - 16:12:53 CST