Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

the meaning of the statistic "bytes sent via SQL*Net to client"

user622061Sep 8 2009 — edited Apr 5 2010
hello every DBA,
I need to understand the meaning of the statistic "bytes sent via SQL*Net to client"

#sqlplus / as sysdba
SQL> set autotrace traceonly stat
SQL> select * from TOTO;

70755 rows selected.

Statistics
----------------------------------------------------------
0 recursive calls
0 db block gets
11598 consistent gets
0 physical reads
0 redo size
4008990 bytes sent via SQL*Net to client
52364 bytes received via SQL*Net from client
4718 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
70755 rows processed


1) My connection is local ( sqlplus / as sysdba), So I don't use any sql*net connexion.
2) The size of the table TOTO is about 96M, and total rows = 70755.

My aim is to understand the the meaning of the number 4008990 ?
I try this test many times, this number is the same.


Thanks in advance for your answers.
Majda.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 3 2010
Added on Sep 8 2009
10 comments
8,353 views