Re: question about statspack

  • From: "Niall Litchfield" <niall.litchfield@xxxxxxxxx>
  • To: jkstill@xxxxxxxxx, john40855@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 12 Mar 2008 18:19:18 +0000

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@xxxxxxxxx> 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@xxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l


Other related posts: