FAQ
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

#####################################################################################

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Denham Eva
INET: EvaD_at_TFMC.co.za

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).

Search Discussions

  • Anjo Kolk at Apr 24, 2002 at 8:58 am
    Yep,

    wrong tree. size it like: redo blocks per tx * tx/sec * 3/2 *

    Anjo.

    Denham Eva 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
    -----------------------------------------------------------------------
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Anjo Kolk
    INET: anjo_at_oraperf.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 at Apr 24, 2002 at 9:33 am
    log buffer gets written

    every 3 seconds
    every commit (more or less)
    1/3 full
    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 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).
  • Tim Gorman at Apr 24, 2002 at 2:08 pm
    LOG_BUFFER Parameter QuestionAre you seeing any significant times from wait-events related to redo log buffering?

    Original Message -----
    From: Denham Eva
    To: Multiple recipients of list ORACLE-L
    Sent: Tuesday, April 23, 2002 11:58 PM
    Subject: LOG_BUFFER Parameter Question

    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

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Tim Gorman
    INET: Tim_at_SageLogix.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).
  • Gogala, Mladen at Apr 24, 2002 at 6:12 pm
    Alternatively, you size it until redo_log_space_wait goes away from
    v$system_events.

    -----Original Message-----
    Sent: Wednesday, April 24, 2002 4:59 AM
    To: Multiple recipients of list ORACLE-L

    Yep,

    wrong tree. size it like: redo blocks per tx * tx/sec * 3/2 *

    Anjo.


    Denham Eva 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
    <http://www.marshalsoftware.com>

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Gogala, Mladen
    INET: MGogala_at_oxhp.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).
  • Ray Stell at Apr 24, 2002 at 6:37 pm

    On Wed, Apr 24, 2002 at 10:12:22AM -0800, Gogala, Mladen wrote:
    Alternatively, you size it until redo_log_space_wait goes away from
    v$system_events.
    it is v$system_event
    -----Original Message-----
    Sent: Wednesday, April 24, 2002 4:59 AM
    To: Multiple recipients of list ORACLE-L


    Yep,

    wrong tree. size it like: redo blocks per tx * tx/sec * 3/2 * blocksize>


    Anjo.



    Denham Eva 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
    <http://www.marshalsoftware.com>
    _____
    --
    ===============================================================
    Ray Stell stellr_at_vt.edu (540) 231-4109 KE4TJC 28^D
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Ray Stell
    INET: stellr_at_cns.vt.edu

    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).
  • Denham Eva at Apr 25, 2002 at 9:03 am
    Thanks to all of you on this issue...


    -----Original Message-----
    Sent: Wednesday, April 24, 2002 8:12 PM
    To: Multiple recipients of list ORACLE-L

    Alternatively, you size it until redo_log_space_wait goes away from
    v$system_events.

    -----Original Message-----
    Sent: Wednesday, April 24, 2002 4:59 AM
    To: Multiple recipients of list ORACLE-L

    Yep,

    wrong tree. size it like: redo blocks per tx * tx/sec * 3/2 *

    Anjo.


    Denham Eva 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
    <http://www.marshalsoftware.com>

    #####################################################################################

    This e-mail message has been scanned for Viruses and Content and cleared
    by MailMarshal
    For more information please visit www.marshalsoftware.com

    #####################################################################################

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Denham Eva
    INET: EvaD_at_TFMC.co.za

    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).

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedApr 24, '02 at 5:58a
activeApr 25, '02 at 9:03a
posts7
users6
websiteoracle.com

People

Translate

site design / logo © 2021 Grokbase