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

  • From: milist ujang <ujang.milist@xxxxxxxxx>
  • To: oracle-l mailing list <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 20 Mar 2017 11:10:00 +0700

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>

Other related posts: