Do you have any LOBs defined with the nocache nologging attribute ? Regards
Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr Next public appearances: Jan 29th 2004 UKOUG Unix SIG - v$ and x$ March 2004 Hotsos Symposium - The Burden of Proof March 2004 Charlotte NC OUG - CBO Tutorial April 2004 Iceland One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html ____UK___February ____UK___June The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, January 28, 2004 8:09 PM > 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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis 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).