I'd have to run up a quick test to check the rman question - but I'm sure
someone else can answer it instantly (and correctly;)
The answer regarding database links to instances on the same machine is yes -
and though the bytes probably would be going through the tcp stack they'd take
a short cut in the hardware and be able to move much faster than the "real"
network.
Regards
Jonathan Lewis
________________________________________
From: milist ujang <ujang.milist@xxxxxxxxx>
Sent: 20 March 2017 09:42:19
To: Jonathan Lewis
Cc: oracle-l mailing list
Subject: Re: bytes sent via SQL*Net to client more than ethernet bandwidth
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<mailto: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<mailto:oracle-l-bounce@xxxxxxxxxxxxx>
<oracle-l-bounce@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx>> on behalf
of milist ujang <ujang.milist@xxxxxxxxx<mailto: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<http://www.avast.com><https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
--
regards
ujang jaenudin | DBA Consultant (Freelancer)
http://ora62.wordpress.com
http://id.linkedin.com/pub/ujang-jaenudin/12/64/bab
--
//www.freelists.org/webpage/oracle-l
