What's the size of your log buffer, and the redo log file? Do you see any errors/messages in alert.log file that are related to 'checkpoints' or 'log switching'?
- Kirti -----Original Message----- Sent: Friday, March 14, 2003 10:14 AM To: Multiple recipients of list ORACLE-L Do you guys think , adding more log file can help ? I think it should not , cuz any way logwriter is going to write in one datafile at a time , correct ? -ak ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, March 14, 2003 4:32 AM > Arup: > > <NO FLAMES> > The second condition is not quite true. It is 2/3 full in the current > versions. > </NO FLAMES> > > It is very easy to test with the event 10046^8. > > KG > > > --- Arup Nanda <[EMAIL PROTECTED]> wrote: > > AK, > > > > If the log buffer is at least 4MB, then increasing it will not help, > > rather it may hurt. The log buffer is flushed when any of the the > > follwoing occur > > (i) 1 MB is filled up > > (2) 1/3rd is filled up > > (3) every 3 seconds > > (4) when a checkpoint occurs > > (5) when a commit occurs. > > > > Therefore, see if any of these could be the problem. It's easy to > > check #s 4 and 3. > > > > As Kirti suggested, the problem could be due to the redo logs being > > on a busy disk, or even a slow one. > > > > HTH. > > > > Arup > > ----- Original Message ----- > > From: Deshpande, Kirti > > To: Multiple recipients of list ORACLE-L > > Sent: Thursday, March 13, 2003 8:13 PM > > Subject: RE: log buffer space > > > > > > Increasing log_buffer size is an option, if it is really small. > > I would also check if the redo logs are on a busy disk. If so, try > > moving those (or other busy data files on the same disk) to other > > not-so-busy disks. > > > > - Kirti > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
