RE: Single-task message waits

From: <Govind.Arumugam_at_alltel.com>
Date: Tue, 03 Dec 2002 17:58:50 -0800
Message-ID: <F001.00511A34.20021203175850@fatcity.com>

This is what I got from metalink for an earlier case.

'single-task message' waits are Waiting for a client message, but in single task mode. Single task mode is when a process communicates directly with the SGA, as opposed to communicating through a background shadow process. even though you are using the a client-server setup (as opposed to single-task), single task is still used internaly for some operation.

Also opsdiag.sql ignores this wait event as an idle wait event.

Govind

-----Original Message-----

Sent: Tuesday, December 03, 2002 7:54 PM To: Multiple recipients of list ORACLE-L

Rick:

ANjo Kolk classifies this wait event under one of the IDLE wait events.i.e nothing to worry if you see them in excessive.

Best Regards,
K Gopalakrishnan

-----Original Message-----

Sent: Tuesday, December 03, 2002 3:10 PM To: Multiple recipients of list ORACLE-L

Hey all,

Does anyone have an idea as to how to tackle "single-task" message waits on 8.1.7? The most I could find on this is that it may have to do with Context indexes, which are referenced in the massive package I'm helping test with a developer.

I'd really like to drop the amount of waits I'm seeing on this because it accounts for ~300-400ms/sec wait according to Spotlight. I had a 10046 trace running too, but I'm having problems setting max_dump_file_size for another process, so I only have 10MB worth of logfile (about 3 minutes of a 30 minute process). But that's another post. :)

TIA,
Rich

Rich Jesse                           System/Database Administrator
Rich.Jesse_at_qtiworld.com              Quad/Tech International, Sussex, WI USA

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

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

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: K Gopalakrishnan
  INET: kaygopal_at_yahoo.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).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: <Govind.Arumugam_at_alltel.com
  INET: Govind.Arumugam_at_alltel.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). Received on Tue Dec 03 2002 - 19:58:50 CST