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

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 20 Mar 2017 09:54:28 +0000
Message-ID: <MMXP123MB1037998E0E4E8011CA3225F3A53A0_at_MMXP123MB1037.GBRP123.PROD.OUTLOOK.COM>

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_at_gmail.com> 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_at_jlcomp.demon.co.uk<mailto:jonathan_at_jlcomp.demon.co.uk>> 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_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org> <oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org>> on behalf of milist ujang <ujang.milist_at_gmail.com<mailto:ujang.milist_at_gmail.com>> 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
--

http://www.freelists.org/webpage/oracle-l Received on Mon Mar 20 2017 - 10:54:28 CET