I believe Peter meant "SQL*Net message to client" rather than FROM in
his second comment, and generally these messages are not important
though there are times when the values of these statistics can indicate
a problem.
You can reduce these numbers by taking client code that performs a
fixed series of actions in order such as update a for :x then update b
for :x followed by a delete from c for :x and placing the DML into a
stored procedure. Instead of 3 requests to the database followed by 3
responses you now have one request to execute a procedure with one
response saving 4 round trips. Chunks of code like this that are
executed dozens to hundreds of time per day offer significant
reductions in network traffic when they are converted to stored code.
Otherwise, the statistics are not an issue.
HTH -- Mark D Powell --
Received on Fri Jan 14 2005 - 08:47:50 CST
