RE: top waits

Or it's time spent dealing with Oracle's Context/Intermedia/Text indexes. And if that's the case, there's nothing that can be done to reduce it according to Oracle Support. See the other thread you (Seema) started on the same subject.

Rich

Rich Jesse                           System/Database Administrator
Rich.Jesse_at_qtiworld.com              Quad/Tech International, Sussex, WI USA

> -----Original Message-----
> From: Cary Millsap [mailto:cary.millsap_at_hotsos.com]
> Sent: Friday, December 20, 2002 11:54 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: top waits
>
>
> 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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: Rich.Jesse_at_qtiworld.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).