RE: Space Contention and LOG_BUFFER size

From: Farnsworth, Dave <DFarnsworth_at_Ashleyfurniture.com>
Date: Wed, 31 Jul 2002 04:33:19 -0800
Message-ID: <F001.004A724D.20020731043319@fatcity.com>

My LOG_BUFFER = 32768

This seems a bit small.

-----Original Message-----
Sent: Wednesday, July 31, 2002 6:13 AM
To: Multiple recipients of list ORACLE-L

No it does not - but the 'redo log space requests' (imho) is not a good stat for log buffer space sizing, since its common to get this number going up when you switch logs (because briefly everyone is told 'hands off the log buffer').

I prefer the 'log buffer space' wait in
v$system_event, v$session_event. Its rare in "typical" systems for a log buffer over (say) 512-1024k to provide any benefit.

hth
connor

• "Farnsworth, Dave" <DFarnsworth_at_Ashleyfurniture.com> wrote: > I am doing some performance monitoring on an 8.1.7
  > DB on Windoze. I ran the following query;
  >
  > SQL> select name,value
  > 2 from v$sysstat
  > 3 where name = 'redo log space requests';
  >
  > NAME
  > VALUE
  >

  ---

  
  > ----------
  > redo log space requests
  > 27
  >
  >
  > If the number of 'redo log space requests' is much
  > over zero then I should increase the LOG_BUFFER size
  > in my init.ora, at least that is what I get from
  > RTFM. One question I have is that does the size of
  > the LOG_BUFFER parameter have to be a multiple of
  > the DB_BLOCK_SIZE parameter? I vaguely remember
  > that it shuold be but have not found anything in TFM
  > to verify this.
  >
  > Thanks,
  >
  > Dave
  > --
  > Please see the official ORACLE-L FAQ:
  > http://www.orafaq.com
  > --
  > Author: Farnsworth, Dave
  > INET: DFarnsworth_at_Ashleyfurniture.com
  >
  > 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).
  

  ---

Connor McDonald
http://www.oracledba.co.uk
http://www.oaktable.net

"Remember amateurs built the ark - Professionals built the Titanic"

---

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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Farnsworth, Dave
  INET: DFarnsworth_at_Ashleyfurniture.com

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 Jul 31 2002 - 07:33:19 CDT