Oracle-L: RE: top waits

From: Cary Millsap <cary.millsap_at_hotsos.com>
Date: Fri, 20 Dec 2002 21:53:37 -0800
Message-ID: <F001.00520B9B.20021220215337@fatcity.com>

It's time spent in your client application, either waiting for user input or legitimately doing work in the front-end process.

Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- Hotsos Clinic 101, Jan 7-9 Knoxville

Steve Adams's Miracle Master Class, Jan 13-15 Copenhagen
2003 Hotsos Symposium, Feb 9-12 Dallas

-----Original Message-----

Singh
Sent: Friday, December 20, 2002 11:05 AM To: Multiple recipients of list ORACLE-L

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=73 24&DI=7474&SU=
http://www.hotmail.msn.com/cgi-bin/getmsg&HL=1216hotmailtaglines_addphot os_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).

--

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