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).
Received on Tue Sep 16 2003 - 15:39:54 CDT
