Re: single-task message

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

-- 
----------------------------------------------------------------
Anjo Kolk
http://www.oraperf.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Anjo Kolk
  INET: anjo_at_oraperf.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).