RE: question about statspack

From: Cary Millsap <>
Date: Wed, 12 Mar 2008 09:17:00 -0600
Message-ID: <>


I wrote a while back about how we know that the <SQL*Net message to client> event is mis-instrumented, and Tanel has blogged about it as well. These two links should help you: age-to-client-isn2019t-what-you-might-think-it-is/?searchterm="sql*net%2 0message%20to%20client
sage-to-client-isn2019t-what-you-might-think-it-is/?searchterm=%22sql*ne t%20message%20to%20client> " -more-data-to-client/).  

Bottom line is that you're never going to see a lot of time in the
<SQL*Net message to client> bucket, but the #calls statistic is a
reliable indication of how many round-trips your application is inflicting upon your end-user response time. That time is tallied into the <SQL*Net message from client> event.    

Cary Millsap

Hotsos Enterprises, Ltd.

Nullius in verba  

Hotsos Symposium 2009 / March 8-12 / Dallas

Visit for curriculum and schedule details...

[] On Behalf Of John Smith Sent: Wednesday, March 12, 2008 8:19 AM
Subject: question about statspack  

I have a statspack report with this line as one of the wait events:

SQL*Net message to client 7,255,516 0 3 0 900.0

As you can see, the number of waits is very high, but the actual time is only 3 seconds in the course of an hour. Is this something I need to be concerned about?

Received on Wed Mar 12 2008 - 10:17:00 CDT

Original text of this message