Re: log buffer space

50 log switches per hour is a LOT. Get it down to a handful or so by increasing the size of the redo logs with a factor 10 or so. Redo buffer sounds a bit small, and going to 1M in size might help a bit, although there's no guarantee for it.

Mogens

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: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
  INET: mln_at_miracleas.dk

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).