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