top waits

From: Seema Singh <oracledbam_at_hotmail.com>
Date: Fri, 20 Dec 2002 09:04:47 -0800
Message-ID: <F001.0051FFDA.20021220090447@fatcity.com>

Hi
Statspack report shows "Single-task message" wait is highfollowing wait. Top Wait Events

~~~~~~~~~~~~~~~~~                                             Wait     % 
Total
Event                                               Waits  Time (cs)   Wt 

Time
--------------------------------- ------------ ------------ -------

single-task message               125,876     134,869   49.88
db file scattered read            1,569,766   57,201   21.16
log file sync                     9,082       51,477   19.04
control file parallel write       2,314       11,249    4.16

Let me know how to fix single-task message.

Thx
-Seema

---

Add photos to your e-mail with MSN 8. Get 3 months FREE*. http://join.msn.com/?page=features/featuredemail&xAPID=42&PS=47575&PI=7324&DI=7474&SU= http://www.hotmail.msn.com/cgi-bin/getmsg&HL=1216hotmailtaglines_addphotos_3mf

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Seema Singh
  INET: oracledbam_at_hotmail.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 Fri Dec 20 2002 - 11:04:47 CST