Re: "free buffer waits" under eXtreme Transaction Loads

From: Tanel Põder <tanel.poder.003_at_mail.ee>
Date: Tue, 27 Jul 2004 00:52:16 +0300
Message-ID: <394f01c4735a$d1379c30$0a879fd9@porgand>

> 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

One reason would be if your system had bursts of transactions, e.g. insert of several MB arrays of data every second, but not much DML activity in between.

Tanel.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Mon Jul 26 2004 - 16:48:57 CDT