Re: LOG_BUFFER setting question

Directives with expressions like 'close to ' can be very misleading. Check how many
'redo entries' you have, how many 'redo writes'; when compared to these, does your number of requests seem 'far beyond' zero, or relatively close to zero ?

It is very common, by the way, for a log file switch to result in a 'redo log space request'. Typically this may mean a few hundredths of a second of dead time every 15 minutes and is rarely something to worry about.

--
Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

Next Seminar dates:
(see http://www.jlcomp.demon.co.uk/seminar.html )

____Denver_______December 2/4
____England______January 21/23


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


Jan Gelbrich wrote in message ...


>

>NAME                      VALUE (Near 0?)

>------------------------- ---------------

>redo log space requests   2988

>

>This definitely far beyond 0 and also increasing over the last months

...


>