On Wed, Apr 24, 2002 at 10:12:22AM -0800, Gogala, Mladen wrote: > Alternatively, you size it until redo_log_space_wait goes away from > v$system_events.
it is v$system_event > > -----Original Message----- > Sent: Wednesday, April 24, 2002 4:59 AM > To: Multiple recipients of list ORACLE-L > > > Yep, > > wrong tree. size it like: redo blocks per tx * tx/sec * 3/2 *<physical > blocksize> > > > Anjo. > > > > Denham Eva wrote: > > > > > Hello, > > > I have been wondering about how to work out what the optimal LOG_BUFFER > parameter, > compared to the physical size of the REDOLOG file, for the best optimization > and writes from buffer to log. > Or am I barking up the wrong tree? Is there some other way of doing this. > > > i.e. redolog file size is 10M and LOG_BUFFER is 512000. > Can this be optimized better? > > > Denham Eva > Oracle DBA > In UNIX Land > On a quiet Night, you can hear the Windows machines reboot. > > > _____ > > This e-mail message has been scanned for Viruses and Content and cleared by > MailMarshal - For more information please visit www.marshalsoftware.com > <http://www.marshalsoftware.com> > _____ > > -- =============================================================== Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC 28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).