Re: Log_buffer size
Date: Mon, 21 Apr 2008 11:00:57 +0100
42. You get to choose the unit of measure.
More seriously redo log size has nothing whatsoever to do with the SGA size, and really rather a lot to do with your rate of redo generation.
Steve Adams has written about log buffer sizing at http://www.ixora.com.au/tips/tuning/log_buffer_size.htm and whilst some of the details may have changed a bit since then, the base message of that article is still correct in my opinion.
On Mon, Apr 21, 2008 at 6:23 AM, Enkhbold <enkhbold_at_khanbank.com> wrote:
> If Total System Global Area = 5GB, what is best Log_buffer size and Redo
> file size?
-- Niall Litchfield Oracle DBA http://www.orawin.info -- http://www.freelists.org/webpage/oracle-lReceived on Mon Apr 21 2008 - 05:00:57 CDT