Re: what happens in the single-task message?

it's the client (similar to two-task, but just single-task)

http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76961/apa5.htm#212152

	 single-task message
	When running single task, this event indicates that the session waits  
for the client side of the executable.
	Wait Time: Total elapsed time that this session spent in the user  

hth
  Martin

--
Martin Berger    http://berxblog.blogspot.com
--
http://www.freelists.org/archives/oracle-l/



>




> Hello list,

> I'm observing quite a lot of similiar entries in a 10046 (level 8)  

> trace

> file

> created on a 8.1.7.4 running under AIX:

> ...




> Elapsed times include waiting on following events:

>  Event waited on                             Times   Max. Wait  Total

> Waited

>  ----------------------------------------   Waited  ----------

> ------------

>  single-task message                             2        5.19

> 6.05

>  SQL*Net message from client                     3        0.01

> 0.01

>  SQL*Net message to client                       1        0.00

> 0.00

> ****************************************************************************

> ****

>

> There is one primary key index, two other indexes (not unique)

> and a context index on the column verg_bem.

>

> Are there any changes to find out what is causing the system to  

> spend 6

> seconds in

> the single-task message?

>




--
http://www.freelists.org/webpage/oracle-l




application/pkcs7-signature attachment: smime.p7s