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" <cary.millsap_at_hotsos.com>
> Date: 2003/09/17 Wed AM 11:09:50 EDT
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> 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-----
> rgaffuri_at_cox.net
> 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: <rgaffuri_at_cox.net
> INET: rgaffuri_at_cox.net
>
> 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: ListGuru_at_fatcity.com (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: cary.millsap_at_hotsos.com
>
> 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: ListGuru_at_fatcity.com (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: <rgaffuri_at_cox.net
INET: rgaffuri_at_cox.net
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: ListGuru_at_fatcity.com (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).
Received on Wed Sep 17 2003 - 10:34:55 CDT
