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

Home -> Community -> Usenet -> c.d.o.server -> Re: Need help with redo log writer

Re: Need help with redo log writer

From: Andrew Mobbs <andrewm_at_chiark.greenend.org.uk>
Date: 21 Jan 2002 15:40:01 +0000 (GMT)
Message-ID: <Lun*u2Wep@news.chiark.greenend.org.uk>


Sybrand Bakker <postbus_at_sybrandb.demon-verwijderdit.nl> wrote:
>On 18 Jan 2002 17:21:59 -0800, zagni_at_yahoo.com (RZ) wrote:
>
>>Try increasing the log_buffer to 5M
>>
>
>
>The redolog buffer is written to disk
>when it's one third full
>every 3 secs
>or when 1M has been written

Or on a commit, of course. Also when DBWn needs to flush uncommited blocks it'll post LGWR.

>Expanding to 5m won't help a damn.

Agreed.

-- 
Andrew Mobbs - http://www.chiark.greenend.org.uk/~andrewm/
Received on Mon Jan 21 2002 - 09:40:01 CST

Original text of this message

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