Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: LGWR's Writing Habits

RE: LGWR's Writing Habits

From: Gaja Krishna Vaidyanatha <gajav_at_yahoo.com>
Date: Wed, 13 Dec 2000 11:34:52 -0800 (PST)
Message-Id: <10709.124473@fatcity.com>


Hello Steve,

I don't think it has the opposite effect. The function is MAX not MIN. The condition for the 1/3rd full event that forces LGWR to write is when MAX(1 Mb., log_buffer/3) is true.

Here are some examples:

If log_buffer is 512K,
then

    MAX(1 Mb, 170.6K) = 1 Mb.
-- The 1/3rd full event will not kick in as log_buffer is 512K end if;

If log_buffer = 1Mb,
then

    MAX(1 Mb, 333.33K) = 1 Mb.
-- The 1/3rd full event will not kick in as log_buffer is 1 Mb. end if;

If log_buffer = 3 Mb.
then

    MAX(1 Mb, 1 Mb.) = 1 Mb.
-- The 1/3rd full event will kick in as 1/3rd of 3 Mb. is 1 Mb. end if;

If log_buffer = 6 Mb.
then

    MAX(1 Mb, 2 Mb.) = 2 Mb.
-- The 1/3rd full event will kick in as 1/3rd of 6 Mb. is 2 Mb. end if;

Hope that helps,

Gaja


Gaja Krishna Vaidyanatha
Director, Storage Management Products, Quest Software Inc. Office : (972)-304-1170, E-mail : gaja_at_quest.com

Author:Oracle Performance Tuning 101 by Osborne McGraw-Hill "Opinions and views expressed are my own and not of Quest" Received on Wed Dec 13 2000 - 13:34:52 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US