(Whilst I hate "rule of thumb") I'd give it a whirl at
192-256k or thereabouts and see what happens..
hth
connor
- "Farnsworth, Dave"
<DFarnsworth_at_Ashleyfurniture.com> wrote: > My
LOG_BUFFER = 32768
>
> This seems a bit small.
>
> -----Original Message-----
> Sent: Wednesday, July 31, 2002 6:13 AM
> To: Multiple recipients of list ORACLE-L
>
>
> No it does not - but the 'redo log space requests'
> (imho) is not a good stat for log buffer space
> sizing,
> since its common to get this number going up when
> you
> switch logs (because briefly everyone is told 'hands
> off the log buffer').
>
> I prefer the 'log buffer space' wait in
> v$system_event, v$session_event. Its rare in
> "typical" systems for a log buffer over (say)
> 512-1024k to provide any benefit.
>
> hth
> connor
>
> --- "Farnsworth, Dave"
> <DFarnsworth_at_Ashleyfurniture.com> wrote: > I am
> doing
> some performance monitoring on an 8.1.7
> > DB on Windoze. I ran the following query;
> >
> > SQL> select name,value
> > 2 from v$sysstat
> > 3 where name = 'redo log space requests';
> >
> > NAME
>
> > VALUE
> >
>
> > ----------
> > redo log space requests
>
> > 27
> >
> >
> > If the number of 'redo log space requests' is much
> > over zero then I should increase the LOG_BUFFER
> size
> > in my init.ora, at least that is what I get from
> > RTFM. One question I have is that does the size
> of
> > the LOG_BUFFER parameter have to be a multiple of
> > the DB_BLOCK_SIZE parameter? I vaguely remember
> > that it shuold be but have not found anything in
> TFM
> > to verify this.
> >
> > Thanks,
> >
> > Dave
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > --
> > Author: Farnsworth, Dave
> > INET: DFarnsworth_at_Ashleyfurniture.com
> >
> > Fat City Network Services -- (858) 538-5051
> FAX:
> > (858) 538-5051
> > San Diego, California -- Public Internet
> > access / Mailing Lists
> >
>
> > 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).
>
> =====
> Connor McDonald
> http://www.oracledba.co.uk
> http://www.oaktable.net
>
> "Remember amateurs built the ark - Professionals
> built the Titanic"
>
> __________________________________________________
> Do You Yahoo!?
> Everything you'll ever need on one web page
> from News and Sport to Email and Music Charts
> http://uk.my.yahoo.com
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: =?iso-8859-1?q?Connor=20McDonald?=
> INET: hamcdc_at_yahoo.co.uk
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> 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.com
> --
> Author: Farnsworth, Dave
> INET: DFarnsworth_at_Ashleyfurniture.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> 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).
Connor McDonald
http://www.oracledba.co.uk
http://www.oaktable.net
"Remember amateurs built the ark - Professionals built the Titanic"
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Connor=20McDonald?=
INET: hamcdc_at_yahoo.co.uk
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).
Received on Wed Jul 31 2002 - 09:38:43 CDT
