statspack report - SQL*Net data stuff

From: Hub <hub_at_houston.rr.NOSPAM.com>
Date: Wed, 21 May 2003 04:13:37 GMT
Message-ID: <R1Dya.1063$A17.268343@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?

Another symptom is that I will be scp'ing some files from one server to another, then things slow down bigtime for awhile, then they resume normal transfer speed. Any ideas on how I can track down this temporary congestion, and might it be related to the SQL*Net waits?

Any info much appreciated.. thx! Received on Tue May 20 2003 - 23:13:37 CDT