Re: redo logs tuning?

Andrew Zhilenko wrote:
>
> 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

Sounds like they could be a little small...

But one very easy way of avoiding a lot of grief with redo logs, is to make them raw.

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse