Re: question about statspack

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Wed, 12 Mar 2008 18:19:18 +0000
Message-ID: <7765c8970803121119n58e5d0a8oad845c3b59b60171@mail.gmail.com>


Ah but message TO client is associated with message FROM client and other row at a time things. Sometimes counts do count.

On 12/03/2008, Jared Still <jkstill_at_gmail.com> wrote:
> You could work on eliminating these waits...
>
> ... and save 3 seconds an hour.
>
> How long and hard do you want to work to improve response time by
> an imperceptible amount? ( 3/7,255,516)
>
> :)
>
> Jared
>
>
> On Wed, Mar 12, 2008 at 6:18 AM, John Smith <john40855_at_gmail.com> wrote:
>
> > 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?
> >
>
>
>
> --
> Jared Still
> Certifiable Oracle DBA and Part Time Perl Evangelist
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Mar 12 2008 - 13:19:18 CDT

Original text of this message