Re: CHECKPOINT?

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