RE: single-task message

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
Rich.Jesse_at_qtiworld.com              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:anjo_at_oraperf.com]
> 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

-- 
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).