| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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).Received on Wed Sep 17 2003 - 10:09:50 CDT
 |
 |