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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
