I am just reading the chapter "Instance Tuning-The Redo Log Buffer and Miscellaeous
Tuning" from Performance Tuning 101. I'll digest that and then act. I am not in a
desparate situation and don't want to just cahnge things for the sake of just changing
them. RTFM first, hose things up later!!
Thanks,
Dave
-----Original Message-----
Sent: Wednesday, July 31, 2002 11:27 AM
To: [EMAIL PROTECTED]
Cc: Farnsworth, Dave
But are you getting unreasonable wait times for the buffer?
Jared
"Farnsworth, Dave" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
07/31/2002 05:33 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: RE: Space Contention and LOG_BUFFER size
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"
<[EMAIL PROTECTED]> 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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
