Oracle-L: RE: Single-task message waits

From: Cary Millsap <cary.millsap_at_hotsos.com>
Date: Wed, 04 Dec 2002 08:14:23 -0800
Message-ID: <F001.0051210D.20021204081423@fatcity.com>

If...

you're collecting time consumption data for ONLY the session you care about, AND
you're collecting the data for a time interval [t0,t1] that includes ONLY response time that you care about eliminating,

...then the waits are worth investigating.

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-----
Rich
Sent: Wednesday, December 04, 2002 9:54 AM To: Multiple recipients of list ORACLE-L

But since my case is a single package running, there's no end-user interaction. If I understand you correctly, then I'm only collecting response time. I guess I never thought of it in those terms for non-interactive executions. If that's the case, then aren't the waits worth
investigating? Or am I off track here?

Just trying to get a handle on this in case a miracle happens and I actually
get to attend a Hotsos Clinic... :)

Thanks,
Rich

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

USA
> -----Original Message-----
> From: Cary Millsap [mailto:cary.millsap_at_hotsos.com]
> Sent: Tuesday, December 03, 2002 9:34 PM
> To: Multiple recipients of list ORACLE-L
> Subject: 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
> 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: 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).

Received on Wed Dec 04 2002 - 10:14:23 CST