Re: question about statspack

From: John Smith <john40855_at_gmail.com>
Date: Wed, 12 Mar 2008 13:18:01 -0500
Message-ID: <a4c7620803121118i21ed600do16ab724bf3fff425@mail.gmail.com>


I wasnt worried about the three seconds per hour right now, my concern is this the kind of thing that comes back to bite you later on, when your network activity doubles or triples.

On Wed, Mar 12, 2008 at 11:50 AM, 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
>

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Mar 12 2008 - 13:18:01 CDT

Original text of this message