...58 minutes if I've calculated correctly. And yes, you're right: if you have 50 sessions and 49 are waiting for 1 minute each, then you have 49 minutes of waiting. Any system has an infinite capacity for waiting.
In case you pick up the book "Optimizing Oracle Performance," this phenomenon (what can you do with information like this?) is the subject of pages 210-217. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic 101 in Sydney - Hotsos Symposium 2004, March 7-10 Dallas - Visit www.hotsos.com for schedule details... -----Original Message----- [EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 3:40 PM To: Multiple recipients of list ORACLE-L below means i have about 50 minutes of waits right? this is over 3 hours. This is total waits right? So if I have 50 sessions running and 49 are waiting for 1 minute each, I have 49 minutes of waits right? Top 5 Wait Events ~~~~~~~~~~~~~~~~~ Wait % Total Event Waits Time (cs) Wt Time -------------------------------------------- ------------ ------------ ------- log file parallel write 19,088 145,072 38.38 db file scattered read 118,363 91,804 24.29 db file sequential read 269,416 55,038 14.56 log file sync 3,929 34,053 9.01 enqueue 96 23,852 6.31 ------------------------------------------------------------- Wait Events for DB: BOBAIRD Instance: bobaird Snaps: 1 -13 -> cs - centisecond - 100th of a second -> ms - millisecond - 1000th of a second -> ordered by wait time desc, waits desc (idle events last) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] 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: Cary Millsap 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).
