RE: Single-task message waits

From: Cary Millsap <cary.millsap_at_hotsos.com>
Date: Wed, 04 Dec 2002 10:54:18 -0800
Message-ID: <F001.0051258D.20021204105418@fatcity.com>

Rich,

Well, at least we've cleared up the "whether." Now the question turns to the "why."

Once you have identified a program's dominant response time contributor, solving any optimization problem degenerates to a very simple strategy:

1. Reduce the number of times the dominant contributor's services are required.
2. Reduce the duration per service call of the dominant contributor.

I expect that #2 will be difficult to do in this case, because I'd expect that the single-task driver is probably the fastest conceivable way that two pieces of client-server code can communicate (they're after all in the same executable). Your leverage is probably #1. It's the old adage:

        Q: What's the fastest way to do X?

1. Don't.

Find out whether your process is making more database calls than it needs to be making. Investigate the usual suspects: SQL that doesn't use bind variables and therefore has to be parsed more often than it should be parsed, one-row-at-a-time manipulation instead of using arrays and bulk features, and so on.

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 10:59 AM To: Multiple recipients of list ORACLE-L

Hey Cary,

"Yes" and "Yes". Which brings me back to my original question: How do I go
about tracking down "single-task message" waits?

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: Wednesday, December 04, 2002 10:14 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Single-task message waits
>
>
> If...
>
> 1) you're collecting time consumption data for ONLY the
> session you care
> about, AND
>
> 2) 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.
>

-- 
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 - 12:54:18 CST