RE: LOG_BUFFER Parameter Question

[Denham Eva]

Thanks to all of you on this issue...

 

-----Original Message-----
From: Gogala, Mladen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 24, 2002 8:12 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: LOG_BUFFER Parameter Question

Alternatively, you size it until redo_log_space_wait goes away from v$system_events.

-----Original Message-----
From: Anjo Kolk [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 24, 2002 4:59 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: LOG_BUFFER Parameter Question

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

---

---

This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit www.marshalsoftware.com

---