Re: log buffer space

It's a fantastic ratio :-).

Anjo Kolk wrote:

>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: =?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).