you dont need to hawk your book... of course ill buy it. yeah. i think im screwed. I dont have mount points to multi-plex my redo logs. :( > > From: "Cary Millsap" <[EMAIL PROTECTED]> > Date: 2003/09/17 Wed AM 11:09:50 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: wait event question > > ...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). >
-- 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).
