Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: log buffer space

Re: log buffer space

From: Anjo Kolk <anjo_at_oraperf.com>
Date: Fri, 14 Mar 2003 15:59:02 -0800
Message-ID: <F001.0056AF8B.20030314155902@fatcity.com>

1 log switch per minute ;-)

AK wrote:
>
> log buffer is 320 K and log files are 30M approx. there are about 50 log
> switch /hr .
>
> -ak
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Friday, March 14, 2003 9:29 AM
>
> > AK,
> >
> > Could you provide the redo log sizes and the log_buffers parameters,
> please.
> > Also let us know the log switch frequency, too.
> >
> > Thanks.
> >
> > Arup
> >
> > ----- Original Message -----
> > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> > Sent: Friday, March 14, 2003 11:14 AM
> >
> >
> > > 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" <ORACLE-L_at_fatcity.com>
> > > 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 <orarup_at_hotmail.com> 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
> > > >
> > > >
> > > > =====
> > > > Have a nice day !!
> > > > ------------------------------------------------------------
> > > > Best Regards,
> > > > K Gopalakrishnan,
> > > > Bangalore, INDIA.
> > > > --
> > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > > --
> > > > Author: K Gopalakrishnan
> > > > INET: kaygopal_at_yahoo.com
> > > >
> > > > 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: ListGuru_at_fatcity.com (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).
> > > >
> > > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > --
> > > Author: AK
> > > INET: oramagic_at_hotmail.com
> > >
> > > 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: ListGuru_at_fatcity.com (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).
> > >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Arup Nanda
> > INET: orarup_at_hotmail.com
> >
> > 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: ListGuru_at_fatcity.com (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).
> >
> >
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: AK
> INET: oramagic_at_hotmail.com
>
> 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: ListGuru_at_fatcity.com (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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Anjo Kolk
  INET: anjo_at_oraperf.com

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: ListGuru_at_fatcity.com (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).
Received on Fri Mar 14 2003 - 17:59:02 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US