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 [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > -----Original Message----- > From: Cary Millsap [mailto:[EMAIL PROTECTED]] > 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
