Re: Redo Log Problem

(re getting high number of log buffer space requests,)

"Connor McDonald" <connor_mcdonald_at_yahoo.com> wrote in message news:3A38B474.554E_at_yahoo.com...
>
> The "'space requests' implies make buffer bigger" is typically an
> incorrect assertion - you will always get some space requests when a log
> file switches - I'd only look at increasing the log buffer if
> a) you are getting these outside the times when you are log switching
> b) your log files are optimal (ie size, disk layout etc )
>

If you're "always" getting space req's, is that not a hint of a perhaps too slow disk system for log files? The round-robin fashion and LGWR behaviour should allow for having free space when the need arises, as long as the burst writing to log files is quick enough, right? (assuming no batch inserts or the-like)

Isn't the script asking too much, expecting =0 (should be always zero)?

Regards
/Fad Received on Tue Dec 19 2000 - 17:55:32 CST