Re: Redo log buffer size

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Mon, 06 Nov 2006 06:41:30 +0000
Message-ID: <yZWdnTDM0s-JRNPYRVnyvA@pipex.net>

Charles Hooper wrote:

> oracle dba wrote:

>> Hi all,
>>
>> According to books redo will to written to file after 1MB is full. So
>> is there any way that our redo log buffer is equal to or more than
>> 10MB.
>> If yes then why ..........................
>> if u know any metalink addr pls inform

> 
> Granule size can force the LOG_BUFFER value to 16MB, even if LOG_BUFFER
> is explicitly set to 1MB in the initialization parameters.
>

I think you'll find that only dynamically resizable components of the sga are allocated in granules and that LOG_BUFFER does not meet that requirement.

regards

Niall Litchfield
Oracle DBA
http://www,orawin.info/ Received on Mon Nov 06 2006 - 00:41:30 CST