Re: what happens in the single-task message?
- From: Martin Berger <martin.a.berger@xxxxxxxxx>
- To: martin.busik@xxxxxxxx
- Date: Tue, 2 Dec 2008 11:30:36 +0100
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
application.
hth
Martin
--
Martin Berger http://berxblog.blogspot.com
--
//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?
Other related posts:
