How did you determine the size of the logs? Or are you just guessing that they are significantly less than 250m?
Could just be a very busy database that needs redo and controlfile on faster disk. Jared On Wed, 2004-01-28 at 12:24, Mladen Gogala wrote: > Increase redo logs to 250M each. You're checkpointing. > > > On 01/28/2004 03:09:26 PM, dba1 mcc wrote: > > WE have ORACLE 9.2.0.3 database run under Win2000. I > > run "statspack" and found "Top 5 timed event". Look > > like "control file parallel write " and "redo file > > parallel write " take lots time. How to fix? > > > > > > > > > > > > Top 5 Timed Events > > ~~~~~~~~~~~~~~~~~~ > > % Total > > Event > > Waits Time (s) Ela Time > > -------------------------------------------- > > ------------ ----------- -------- > > control file parallel write > > 5,499 1,141 90.37 > > CPU time > > 97 7.70 > > log file parallel write > > 1,305 12 .95 > > db file parallel write > > 162 6 .44 > > log file switch completion > > 10 2 .16 > > > > ------------------------------------------------------------- > > Wait Events for DB: 9IDEV Instance: 9idev Snaps: 5 > > -6 > > -> s - second > > -> cs - centisecond - 100th of a second > > -> ms - millisecond - 1000th of a second > > -> us - microsecond - 1000000th of a second > > -> ordered by wait time desc, waits desc (idle events > > last) > > > > > > Avg > > > > Total Wait wait Waits > > Event Waits Timeouts > > Time (s) (ms) /txn > > ---------------------------- ------------ ---------- > > ---------- ------ -------- > > control file parallel write 5,499 0 > > 1,141 207 211.5 > > log file parallel write 1,305 1,299 > > 12 9 50.2 > > db file parallel write 162 0 > > 6 34 6.2 > > log file switch completion 10 0 > > 2 204 0.4 > > control file sequential read 3,827 0 > > 2 0 147.2 > > db file sequential read 176 0 > > 1 7 6.8 > > direct path write 92 0 > > 1 6 3.5 > > log file sync 14 0 > > 0 33 0.5 > > log file single write 20 0 > > 0 13 0.8 > > log file sequential read 35 0 > > 0 6 1.3 > > direct path read 92 0 > > 0 2 3.5 > > SQL*Net break/reset to clien 44 0 > > 0 0 1.7 > > SQL*Net more data to client 7 0 > > 0 0 0.3 > > async disk IO 4 0 > > 0 0 0.2 > > virtual circuit status 6,826 496 > > 19,650 2879 262.5 > > wakeup time manager 530 530 > > 19,179 36187 20.4 > > SQL*Net message from client 6,457 0 > > 12,084 1871 248.3 > > jobq slave wait 402 381 > > 1,227 3051 15.5 > > SQL*Net message to client 6,458 0 > > 0 0 248.4 > > > > ------------------------------------------------------------- > > Background Wait Events for DB: 9IDEV Instance: 9idev > > Snaps: 5 -6 > > -> ordered by wait time desc, waits desc (idle events last) > > > > __________________________________ > > Do you Yahoo!? > > Yahoo! SiteBuilder - Free web site building tool. Try it! > > http://webhosting.yahoo.com/ps/sb/ > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: dba1 mcc > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > > San Diego, California -- Mailing list and web hosting services > > --------------------------------------------------------------------- > > 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). > > > > -- > Mladen Gogala > Oracle DBA > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).
