One thing to consider here is that "single-task message" and "SQL*Net message from client" are basically (single-task vs. two-task) the same, but I rather have the "single-task message" wait.
Anjo. On Thursday 02 January 2003 14:03, you wrote: > True. And even if you're waiting 30% of your elapsed time in "single-task > message" (very significant for us on hour-long table loads), Oracle Support > says there's not a damn thing you can do about it. From my recent iTAR > closed Christmas Day 2002: > > Oracle use to have a single task mode, client application access SGA > directly, > rather than now all connections are in two task mode, or client-server > mode, client application access SGA through a server shadow process. But > single task > still used somewhere internally. In you case, it could be when building > intermedia index. > But it's out of user's control. > > If it's a load of a table or some such, and you are able to load it without > the Context/Intermedia/OracleText index in place, by all means do so. In > our case, some of the updates to the table being loaded required the use of > the Context index to be in place (very poor 3rd-party design buried data in > a free-format text field). > > Sorry to be late on this with the Holidaze and all. Good luck! > > Rich > > Rich Jesse System/Database Administrator > [EMAIL PROTECTED] Quad/Tech International, Sussex, WI > USA > > For sale: 1 (one) used 4MB Palm Pilot IIIx w/leather Targa case. Doesn't > like being jammed in car doors with an Altoids tin, so it would like new > glass and LCD (and possibly more). Yours for only a 12-pack of Guinness > 15.9oz cans if you give me a postage-paid return box. <sigh> And > Christmas has come and gone. Figures. > > > -----Original Message----- > > From: Anjo Kolk [mailto:[EMAIL PROTECTED]] > > Sent: Friday, December 27, 2002 1:39 AM > > To: Multiple recipients of list ORACLE-L > > Subject: Re: single-task message > > > > > > > > This event is making a come back. Single task linking was a > > way in V5 and V6 > > (and V7) to make applications run very fast. It was no longer > > supported by > > oracle. However, now withe the Context option (or what ever > > it is called > > today) it is back. "single task message" = "SQL*net message > > from client". > > > > Anjo. > > > > On Thursday 26 December 2002 10:34, Seema Singh wrote: > > > Hi > > > Wondering one of database is showing "single-task message " > > > > high wait. > > > > > Let me know what to do to fix this pl? > > > thx > > > -Seema -- ---------------------------------------------------------------- Anjo Kolk http://www.oraperf.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anjo Kolk 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).