"Hub" <hub_at_houston.rr.NOSPAM.com> wrote in message news:<R1Dya.1063$A17.268343_at_twister.austin.rr.com>...
> We're having some weird network problems and I think I'm seeing some of it
> in the statspack report. Here is an excerpt:
>
>
> Event Waits Timeouts Time (s) (ms)
> /txn
> ---------------------------- ------------ ---------- ---------- ------ -----
> ---
> db file sequential read 7,959,227 0 4,678 1
> 10.3
> db file scattered read 5,581,367 0 2,948 1
> 7.3
> log file sync 824,640 160 2,195 3
> 1.1
> SQL*Net more data to client 17,819,017 0 1,317 0
> 23.2
> <snip>
> SQL*Net message from client 133,289,942 0 ########## 190
> 173.3
>
> Are those SQL*Net values excessive?
What's ok and what's excessive depends on your environment. However,
from SQL*Net more data to client numbers, I would recommend you,
definitely look for network issues, because number of waits and time
waited is bigger (in relation to other waits) than usually should be.
But as I've already said, it depends on your environment. For example
if you're running your application over some kind of WAN or even
mobile services, then this numbers can be more than satisfying.
--
_________________________________________
Dusan Bolek, Ing.
Oracle team leader
Note: pagesflames_at_usa.net has been cancelled due to changes (maybe we
can call it an overture to bankruptcy) on that server. I'm still using
this email to prevent SPAM. Maybe one day I will change it and have a
proper mail even for news, but right now I can be reached by this
email.
Received on Wed May 21 2003 - 09:53:28 CDT
