Re: "free buffer waits" under eXtreme Transaction Loads
- From: "Juan Carlos Reyes Pacheco" <jreyes@xxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 26 Jul 2004 17:39:43 -0400
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@xxxxxxxxxxxxx
Date: 07/26/04 17:31:40
To: oracle-l@xxxxxxxxxxxxx
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
----- Original Message -----
From: "Juan Carlos Reyes Pacheco" <jreyes@xxxxxxxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Monday, July 26, 2004 2:07 PM
Subject: Re: "free buffer waits" under eXtreme Transaction Loads
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@xxxxxxxxxxxxx
Date: 07/26/04 16:54:41
To: oracle-l@xxxxxxxxxxxxx
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
----- Original Message -----
From: "Juan Carlos Reyes Pacheco" <jreyes@xxxxxxxxxxxxxxxx>
Could I ask you please if is possible in your tests to incrase to 10M, test
and share if this improves in some way your performance.
Thank you in advance
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
