Re: REDO log shifts are blocking for DB updates !!!

At a log switch (possibly at every chkpt, I can't remember) the SGA is flushed which takes time and resources. In order to minimize the impact of log switches, create larger log files. You could even create a log file to hold more than the daily average worth of redo transactions. The one immediate downside to larger log files is that crash recovery time increases.

>> Since transaction also contains updates, the REDO log file fills up and
>> are switches on regular basis. During the switch the update statements
>> are stalled/delayed for the same amount of time as it takes to switch
>> REDO log file. Why ?????
Received on Sat Mar 01 1997 - 00:00:00 CST