Re: question about statspack
- From: "John Smith" <john40855@xxxxxxxxx>
- To: "Jared Still" <jkstill@xxxxxxxxx>
- Date: Wed, 12 Mar 2008 13:18:01 -0500
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@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
>
Other related posts:
