Re: redo log buffer weirdness

kal121_at_my-deja.com wrote:
>
> Yes.
>
> I wonder if it's picking some default value for some reason. Anyhow,
> I'm going to change it and see what happens.
>
> In article <f5JR4.28$fH.1540_at_news.swbell.net>,
> "spencer" <spencerp_at_swbell.net> wrote:
> > have you restarted the instance to make
> > the parameter change effective ?
> >
> > <kal121_at_my-deja.com> wrote in message
> > news:8f70np$nsl$1_at_nnrp1.deja.com...
> > > Have a question:
> > >
> > > I've set the log_buffer parameter = 32768 in the init.ora
 file.
> > >
> > > However, when I "show sga", it says that the Redo Buffers =
 73728.
> > >
> > > Why is this? Shouldn't they be the same?
> > >
> > >
> > > Sent via Deja.com http://www.deja.com/
> > > Before you buy.
> >
> >
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

There is also a minimum - I can't remember but it some formula like (fiction follows) "64k + 2 x blocksize"

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse