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,
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
(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
[EMAIL PROTECTED] wrote: My
LOG_BUFFER = 32768
This seems a bit small.
-Original Message-
Sent: Wednesday, July 31, 2002 6:13 AM
To: Multiple
Title: RE: Space Contention and LOG_BUFFER size
I believe I read something from Steve Adams that cautioned about setting this buffer too large. One of the conditions that triggers LGWR to flush redo to disk is when the buffer is 1/3 full. Obviously, the larger the buffer size the more
: 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
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
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
More than the number of time you are waiting for 'redo log space requests'
its more important to find out how long you are waiting for that. 27 times
out of a million might not be a big deal for you to tune.
having said that, here is a posting by Steve Adams on this topic
Q : Every day our
I can't find it in the docs either.
Info at ixora.com suggests setting LOG_BUFFER to a multiple of the log block
size.
http://www.ixora.com.au/tips/tuning/log_buffer_size.htm
This next link explains what a log block size is:
http://www.ixora.com.au/notes/log_block_size.htm
Have fun!
Ed
