Re: Redo log buffer size

Niall Litchfield wrote:
> 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.

Also see metalink Note:373018.1 and not-a-bug 4930608

Learn something new every day.

jg

--
@home.com is bogus.
Those kookie banks:  http://catless.ncl.ac.uk/Risks/24.46.html#subj7