Hi Jonathan,
is RMAN will be counted on this stat too?
There are dblinks to other DB in same machine, I think it must be counted
to *dblink stat.
No export, no local application connect by BEQ nor tns even em console was
disabled since beginning.
On Mon, Mar 20, 2017 at 4:04 PM, Jonathan Lewis <jonathan@xxxxxxxxxxxxxxxxxx
wrote:
All bytes between client and server go through SQL*Net, even when the
client and server are on the same machine and the "network" is actually
some form of local inter-process communication. E.g. doing an export on the
server will result (typically) in the bytes passing through the BEQ
protocol, but still appearing as "bytes sent/received via SQL*Net".
Regards
Jonathan Lewis
________________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> on
behalf of milist ujang <ujang.milist@xxxxxxxxx>
Sent: 20 March 2017 04:10:00
To: oracle-l mailing list
Subject: bytes sent via SQL*Net to client more than ethernet bandwidth
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://ipmcdn.avast.com/images/icons/icon-envelope-
tick-round-orange-animated-no-repeat-v1.gif]<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>