I think you mean you want to slow down the rate of redo log switching. Redo
is generated by making changes to the data so there's not much you can do
about that (if it were inserts you could do direct sqlload to avoid the redo
or you could create tables with nologging clause so that dml would skip the
redo). Outside of that, are you seeing any performance degradation because
of the log switches (there is anything necessarily bad about frequent log
switching unless your machine or disk system can't keep up)? If you want to
delay log switching, just make your redo logs bigger. I have one system
where the redo logs are over 1GB in size (recovery time, however, is quite
long).
Received on Sun Oct 24 1999 - 20:27:31 CDT
