Re: REDO log shifts are blocking for DB updates !!!
From: Shane Murray <smurray_at_bah.com>
Date: 1997/03/01
Message-ID: <3318223c.377288753_at_news>#1/1
Date: 1997/03/01
Message-ID: <3318223c.377288753_at_news>#1/1
[Quoted] 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 CET