db:oracle:sql_net_statistics

Table of Contents

About

The SQL*Net Statistics are a part of the autotrace statistics and you can find three parts on it :

How much you sent to the server : bytes received via SQL*Net from client
How much the server send to you : Oracle Database - bytes sent via SQL*Net to client
How much SQL*Net mesages are sent to and received from the client : Oracle Database - SQL*Net roundtrips to from client. This includes round-trips for fetches from a multiple-row result set.

Articles Related

How to minimize

You can't really influence the first statistics.

the data sent to you ?

by selecting only the columns that are relevant to you. No select * from.

the number of round-trips ?

SQL PLUS - Array size