| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: "free buffer waits" under eXtreme Transaction Loads
Thanks Terry, I agree with you, I only want to know if changing this
parameter would alter his statistics in anyway.
In theory all should be similar, it was only testing theories, curiosity.
:)
Juan Carlos Reyes Pacheco
OCP
-------Original Message-------
From: oracle-l_at_freelists.org
Date: 07/26/04 17:31:40
To: oracle-l_at_freelists.org
Subject: Re: "free buffer waits" under eXtreme Transaction Loads
Just to clarify, it's not my situation, it's Vivek's. He's welcome to do whatever he wants. But I don't see the value of changing something without a reason to change it. I don't know what the contradictory theories are, but I've seen way too many people create huge log buffers because it said in some Oracle document that log_buffer should be increased if redo log space requests are not near-zero, without considering what near-zero really means. I have yet to hear a good reason for a log buffer larger than 1MB (I'm happy to consider it if I hear such a reason, but not until). Granted, I've never seen a system generating 6MB/second of redo (the most I've worked with was 1/3 that), but I'd still want to hear good logic before I tried something.
--Terry
Hi Terry,
The reason is because I would like to test the impact of a 10m size log
buffer space in your situation.
I understand if you reject, but if possible, only to see what implies it ;),
because there are
several contradictories theories about a 10M size, I would like to see what
happens, I think
this will be interesting, if this not takes to you too much time
Thanks in advance.
Juan Carlos Reyes Pacheco
OCP
-------Original Message-------
From: oracle-l_at_freelists.org
Date: 07/26/04 16:54:41
To: oracle-l_at_freelists.org
Subject: Re: "free buffer waits" under eXtreme Transaction Loads
Why would you want him to do this. If his log buffer were too small, wouldn't he be seeing "log buffer space" waits? I'd expect "log file sync" waits to get worse with a larger log buffer.
--Terry
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
 |
 |