bytes sent via SQL*Net to client more than ethernet bandwidth

From: milist ujang <ujang.milist_at_gmail.com>
Date: Mon, 20 Mar 2017 11:10:00 +0700
Message-ID: <CACG9ogxMJAQ7ycGrP8yoEp7NT+1L7wbH+S4=gtkt3hh1XPCV3A_at_mail.gmail.com>

Hi all,

grab an awr report for 1 hour snapshot, got this interesting result:

Statistic                                     Total     per Second     per

Trans

-------------------------------- ------------------ --------------
-------------
bytes received via SQL*Net from       3,389,355,311    1,041,664.1
 33,689.1
bytes received via SQL*Net from      23,274,085,007    7,152,917.7

231,336.6
bytes sent via SQL*Net to client 750,089,913,974 230,528,136.3 7,455,643.4
bytes sent via SQL*Net to dblink 620,390,482 190,667.1 6,166.5

how can "bytes sent via SQL*Net to client" statistic higher than ethernet bandwidth? (1 Gbps = 128 MB/s).
sparc Solaris 11, oracle 11.2.0.3.

-- 
regards

ujang jaenudin | DBA Consultant (Freelancer)
http://ora62.wordpress.com
http://id.linkedin.com/pub/ujang-jaenudin/12/64/bab



<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>


Virus-free.
www.avast.com


<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>


<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>



--
http://www.freelists.org/webpage/oracle-l

Received on Mon Mar 20 2017 - 05:10:00 CET