Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> redo logs tuning?

redo logs tuning?

From: Andrew Zhilenko <andrew_at_nextra.com>
Date: Sun, 03 Sep 2000 20:10:08 +0200
Message-ID: <39B29400.64F07199@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

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 Sun Sep 03 2000 - 13:10:08 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US