Re: CHECKPOINT?

From: Seema Singh <oracledbam_at_hotmail.com>
Date: Wed, 30 Jan 2002 06:54:17 -0800
Message-ID: <F001.00400594.20020130065022@fatcity.com>

Mogen
I checked log file sync is increasing

log file sync                             41355      276686

I set log_checkpoint_interval and log_checkpoint_timeout is ZERO. The diffrence between background checkpoints Completed and background checkpoints started is always 1. What can I do for this correction.
THx
-Seema

>From: Mogens Nørgaard <mln_at_miracleas.dk>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: CHECKPOINT?
>Date: Tue, 29 Jan 2002 08:00:43 -0800
>
> Log file sync is another name for commit. So have fewer commits or
>make them faster is the extremely short answer. But these values are
>taking out of context - if the time_waited for log file sync is small
>compared to the total response time, then who cares? :).
>
>Mogens
>
>Seema Singh wrote:
>
>>
>>Hi
>>I checked the following events
>>Name total_waits time_waited
>>log file switch completion 18 1188
>>log file sync 99909 667388
>>
>>This value is increasing.I checked following stats and found ok.
>>background checkpoints Completed 15
>>background checkpoints started 16
>>Oracle suggest if above wait events is repeated frequently with
>>considerable values then we need to atke a action like adding more
>>redo log files or increasing their sizes or modifying checkpointing
>>parameters.
>>Thanks
>>-Dinesh
>>
>>
>>
>>
>>_________________________________________________________________
>>Get your FREE download of MSN Explorer at
>>http://explorer.msn.com/intl.asp .
>>
>
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Mogens =?ISO-8859-1?Q?N=F8rgaard?=
> INET: mln_at_miracleas.dk
>
>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).

---

Send and receive Hotmail on your mobile device: http://mobile.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Seema Singh
  INET: oracledbam_at_hotmail.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 Jan 30 2002 - 08:54:17 CST