Re: [Q] wait time on stat
Mladen, Here I will humbly disagree with you. It is not fault of Windows but the person who created the database and defined tiny size log files while creation. If he used custom database option he can define whatever size he wants. These options are same for both Windows and Unix. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Wed, 28 Jan 2004 17:54:26 -0800 Defaulty Windows installation usually creates log files of 20M. The person who posted the problem explicitely mentioned Windows platform. Size of 20M is so small that the database will start to checkpoint like crazy when you start using it for real. The number that I gave is my rule of thumb. It's not to big to frighten the boss (alltogether just a gig or two) and it's big enough to solve checkpointing problem. This rule of thumb number is derived from experience. Yes, of course, I am guessing. There is not enough information to investigate the problem. I believe that he was asking us to guess. I did. On 01/28/2004 08:14:25 PM, Jared Still wrote: 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 > > WaitsTime (s) Ela Time > > > > --- > > control file parallel write > > 5,499 1,14190.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 - 100th of a second > > -> ordered by wait time desc, waits desc (idle events > > last) > > > > > > Avg > > > > Total Wait waitWaits > > Event Waits Timeouts > > Time (s) (ms) /txn > > -- > > -- -- > > control file parallel write 5,499 0 > >1,141207211.5 > > log file parallel write 1,305 1,299 > > 12 9 50.2 > > db file parallel write162 0 > >6 34 6.2 > > log file switch completion 10 0 > >2204 0.4 > > control file sequential read3,827 0 > >2 0147.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,826496 > > 19,650 2879262.5 > > wakeup time manager 530530 > > 19,179 36187 20.4 > > SQL*Net message from client 6,457 0 > > 12,084 1871248.3 > > jobq slave wait 402381 > >1,227 3051 15.5 > > SQL*Net message to client 6,458 0 > >0 0248.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 Dieg
Re: [Q] wait time on stat
Hi! > Do you have any LOBs defined with > the nocache nologging attribute ? This was what I initially thought would be the problem, but then I thought, in case of nocache lobs you should see direct path writes (lob) a lot... Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder 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).
RE: [Q] wait time on stat
> -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Mladen Gogala > Sent: 29 January 2004 01:54 > To: Multiple recipients of list ORACLE-L > Subject: Re: [Q] wait time on stat > > > Defaulty Windows installation usually creates log files of 20M. The > person who posted the problem explicitely mentioned Windows > platform. Size of 20M is so small that the database will > start to checkpoint like crazy when you start using it for > real. On 9.2 at least (might be 9.0.1 as well but that isn't in use here) each of the available template databases used by dbca comes with 3 redo logs of 100m each by default. Don't know what the default is if you don't specify a size in the create database statement (never been that daft) but that wouldn't be windows specific. Niall -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield 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).
Re: [Q] wait time on stat
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 > WaitsTime (s) Ela Time > > --- > control file parallel write > 5,499 1,14190.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 - 100th of a second > -> ordered by wait time desc, waits desc (idle events > last) > > > Avg > > Total Wait waitWaits > Event Waits Timeouts > Time (s) (ms) /txn > -- > -- -- > control file parallel write 5,499 0 >1,141207211.5 > log file parallel write 1,305 1,299 > 12 9 50.2 > db file parallel write162 0 >6 34 6.2 > log file switch completion 10 0 >2204 0.4 > control file sequential read3,827 0 >2 0147.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,826496 > 19,650 2879262.5 > wakeup time manager 530530 > 19,179 36187 20.4 > SQL*Net message from client 6,457 0 > 12,084 1871248.3 > jobq slave wait 402381 >1,227 3051 15.5 > SQL*Net message to client 6,458 0 >0 0248.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
RE: [Q] wait time on stat
"Defaulty Windows installation..." Hehehe;-) -Original Message- From: Mladen Gogala [mailto:[EMAIL PROTECTED] Sent: Wed 1/28/2004 8:54 PM To: Multiple recipients of list ORACLE-L Cc: Subject: Re: [Q] wait time on stat Defaulty Windows installation usually creates log files of 20M. The person who posted the problem explicitely mentioned Windows platform. Size of 20M is so small that the database will start to checkpoint like crazy when you start using it for real. The number that I gave is my rule of thumb. It's not to big to frighten the boss (alltogether just a gig or two) and it's big enough to solve checkpointing problem. This rule of thumb number is derived from experience. Yes, of course, I am guessing. There is not enough information to investigate the problem. I believe that he was asking us to guess. I did. On 01/28/2004 08:14:25 PM, Jared Still wrote: > 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 > > > WaitsTime (s) Ela Time > > > > > > --- > > > control file parallel write > > > 5,499 1,14190.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 - 100th of a second > > > -> ordered by wait time desc, waits desc (idle events > > > last) > > > > > > > > > Avg > > > > > > Total Wait waitWaits > > > Event Waits Timeouts > > > Time (s) (ms) /txn > > > -- > > > -- -- > > > control file parallel write 5,499 0 > > >1,141207211.5 > > > log file parallel write 1,305 1,299 > > > 12 9 50.2 > > > db file parallel write162 0 > > >6 34 6.2 > > > log file switch completion 10 0 > > >2204 0.4 > > > control file sequential read3,827 0 > > >2 0147.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,826496 > > > 19,650 2879262.5 > > > wakeup time manager 530530 > > > 19,179 36187 20.4 > >
Re: [Q] wait time on stat
Defaulty Windows installation usually creates log files of 20M. The person who posted the problem explicitely mentioned Windows platform. Size of 20M is so small that the database will start to checkpoint like crazy when you start using it for real. The number that I gave is my rule of thumb. It's not to big to frighten the boss (alltogether just a gig or two) and it's big enough to solve checkpointing problem. This rule of thumb number is derived from experience. Yes, of course, I am guessing. There is not enough information to investigate the problem. I believe that he was asking us to guess. I did. On 01/28/2004 08:14:25 PM, Jared Still wrote: 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 > > WaitsTime (s) Ela Time > > > > --- > > control file parallel write > > 5,499 1,14190.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 - 100th of a second > > -> ordered by wait time desc, waits desc (idle events > > last) > > > > > > Avg > > > > Total Wait waitWaits > > Event Waits Timeouts > > Time (s) (ms) /txn > > -- > > -- -- > > control file parallel write 5,499 0 > >1,141207211.5 > > log file parallel write 1,305 1,299 > > 12 9 50.2 > > db file parallel write162 0 > >6 34 6.2 > > log file switch completion 10 0 > >2204 0.4 > > control file sequential read3,827 0 > >2 0147.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,826496 > > 19,650 2879262.5 > > wakeup time manager 530530 > > 19,179 36187 20.4 > > SQL*Net message from client 6,457 0 > > 12,084 1871248.3 > > jobq slave wait 402381 > >1,227 3051 15.5 > > SQL*Net message to client 6,458 0 > >0 0248.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 H
Re: [Q] wait time on stat
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 > > WaitsTime (s) Ela Time > > > > --- > > control file parallel write > > 5,499 1,14190.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 - 100th of a second > > -> ordered by wait time desc, waits desc (idle events > > last) > > > > > > Avg > > > > Total Wait waitWaits > > Event Waits Timeouts > > Time (s) (ms) /txn > > -- > > -- -- > > control file parallel write 5,499 0 > >1,141207211.5 > > log file parallel write 1,305 1,299 > > 12 9 50.2 > > db file parallel write162 0 > >6 34 6.2 > > log file switch completion 10 0 > >2204 0.4 > > control file sequential read3,827 0 > >2 0147.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,826496 > > 19,650 2879262.5 > > wakeup time manager 530530 > > 19,179 36187 20.4 > > SQL*Net message from client 6,457 0 > > 12,084 1871248.3 > > jobq slave wait 402381 > >1,227 3051 15.5 > > SQL*Net message to client 6,458 0 > >0 0248.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
Re: [Q] wait time on stat
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 WaitsTime (s) Ela Time --- control file parallel write 5,499 1,14190.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 - 100th of a second -> ordered by wait time desc, waits desc (idle events last) Avg Total Wait waitWaits Event Waits Timeouts Time (s) (ms) /txn -- -- -- control file parallel write 5,499 0 1,141207211.5 log file parallel write 1,305 1,299 12 9 50.2 db file parallel write162 0 6 34 6.2 log file switch completion 10 0 2204 0.4 control file sequential read3,827 0 2 0147.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,826496 19,650 2879262.5 wakeup time manager 530530 19,179 36187 20.4 SQL*Net message from client 6,457 0 12,084 1871248.3 jobq slave wait 402381 1,227 3051 15.5 SQL*Net message to client 6,458 0 0 0248.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 -- Author: Mladen Gogala 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).
[Q] wait time on stat
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 WaitsTime (s) Ela Time --- control file parallel write 5,499 1,14190.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 - 100th of a second -> ordered by wait time desc, waits desc (idle events last) Avg Total Wait waitWaits Event Waits Timeouts Time (s) (ms) /txn -- -- -- control file parallel write 5,499 0 1,141207211.5 log file parallel write 1,305 1,299 12 9 50.2 db file parallel write162 0 6 34 6.2 log file switch completion 10 0 2204 0.4 control file sequential read3,827 0 2 0147.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,826496 19,650 2879262.5 wakeup time manager 530530 19,179 36187 20.4 SQL*Net message from client 6,457 0 12,084 1871248.3 jobq slave wait 402381 1,227 3051 15.5 SQL*Net message to client 6,458 0 0 0248.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).
