Re: redo logs tuning?

In parallel to the other replies, Spotlight is overly sensitive, and is in fact only reporting that Log Buffer waits are showing up as the highest wait on your system regardless of the fact that these waits may be within acceptable limits. 65ms is nothing to worry about. It looks like your log files may be on the same disk as data files and/or index files, this would increase the write time as the disk write queue would be slightly higher than if you were to place your logs on isloated disks.

Are your logs isolated ?

"Andrew Zhilenko" <andrew_at_nextra.com> wrote in message news:39B29400.64F07199_at_nextra.com...
> Hello!
>
> I have installed Oracle 8.1.6.2 database on Sparc E220
> with Solaris 7. Right now I mostly do some PL/SQL development.
> I have "Spotlight on Oracle" running almost all the time. And
> almost all the time it complains, that something is wrong
> with the REDO log buffers:
> - Log buffer space waits is XX % of active waits
> - Log switch wait time is is XX % of active waits
> - Average redo log write time is 65.50 ms
> ....
> and explanation says that this operation should be much faster.
> (For example my average time is 65 ms, and it says that "modern
> disks should have this value less than 20 ms")
>
> I have LOG_BUFFER=160K, three redo log files 2M each, no
> archivelog. Can I improve situation somehow?
>
> WBR, Andrew
> --
> Andrew Zhilenko, AZ283-RIPE, System Administrator
> Nextra Czech Republic s.r.o.
> tel.+42-02-96159436 fax. +42-02-96159422
> e-mail: andrew@nextra.com http://www.nextra.cz
> Vaclavske namesti 4 - Praha 1 - 110 00
> Czech Republic
Received on Wed Sep 06 2000 - 18:58:52 CDT