RE: Single-task message waits

But if a so-called idle event is consuming end-user response time, then it *is* something to worry about. The problem with the so-called idle events is that when you see lots of time rack up to them in v$system_event, you can't know whether the time has tallied there because of end-user inactivity or because of some other reason... So in the context where you've collected diagnostic data to include both end-user response time and end-user idle time, you *have to* ignore the "idle events"; you have no other choice.

Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- Hotsos Clinic, Dec 9-11 Honolulu

• Hotsos Clinic 101, Jan 7-9 Knoxville
• Steve Adams's Miracle Master Class, Jan 13-15 Copenhagen
• 2003 Hotsos Symposium, Feb 9-12 Dallas

-----Original Message-----
Gopalakrishnan
Sent: Tuesday, December 03, 2002 6: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

--
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: Cary Millsap
  INET: cary.millsap_at_hotsos.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).