Re: LOG_BUFFER Parameter Question

From: Connor McDonald <hamcdc_at_yahoo.co.uk>
Date: Wed, 24 Apr 2002 01:33:25 -0800
Message-ID: <F001.0044D69D.20020424013325@fatcity.com>

log buffer gets written

1. every 3 seconds
2. every commit (more or less)
3. 1/3 full
4. 1M full

thus its unrelated to redo log file size, and in most cases unlikely that anything above 512k-1m is going to give benefits. Check for 'log buffer waits' in your statspack data.

hth
connor

• Denham Eva <EvaD_at_TFMC.co.za> 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
  >
  #####################################################################################
  >
  

  ---

Connor McDonald
http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"

---

Do You Yahoo!?
Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: hamcdc_at_yahoo.co.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Wed Apr 24 2002 - 04:33:25 CDT