| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: SQL*Net message from client
Indeed. In Hotsos Profiler v4, we already emit range (min/max) information
for call durations. In v5 (currently in development), each resource profile
row contains a histogram /picture/ that gives an instant visual indication
of the skew for a given timed event's durations. In our early testing, this
little picture has proven itself to be extremely effective in conveying the
information the analyst needs without having to break into the raw trace
data.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
* Nullius in verba *
Upcoming events:
- Performance Diagnosis 101: 6/22 Pittsburgh, 7/20 Cleveland, 8/10 Boston
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Jonathan Lewis
Sent: Thursday, June 03, 2004 2:27 AM
To: oracle-l_at_freelists.org
Subject: Re: SQL*Net message from client
Cary,
That looks like an opportunity for your profiler - add a mean, and standard deviation to each wait time you record, then add in the ability to drill down to a histogram showing distribution.
It's interesting to note that one of the enhancements on wait information on 10g is the histogram output. v$event_histogram (system level, but with snapshots it can be informative, and it's definitely interesting even when it doesn't necessarily help on a specific problem)
(And 10g does have the convenient v$session_wait_history, so you can get the last 10 waits with one query - that can help the real-time search).
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk/faq/ind_faq.html The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/seminar.html Optimising Oracle Seminar - schedule updated May 1st
One point of clarification that comes to me upon seeing my own response here... Just adding a COUNT column to the existing output isn't going to reveal the answer you need. You really have to know something about the distribution of snmfc durations (are they uniformly distributed? Or skewed?). You'll only be able to see this by looking at the raw trace data. It is impossible to see in the V$ data unless you poll the V$ fixed views very rapidly (on the order of 100s of times per second).
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Thu Jun 03 2004 - 23:13:16 CDT
 |
 |