Possibly due initially to the fact that ping is ICMP and runs very low in
the TCP/IP stack that is in the network layer or the third level up from
the hardware and TNSPING is application layer which puts it up at the top
of the stack or two more layers higher. This alone can contribute to the
performance or response time differences.
Cheers
--
=================================================
Peter McLarty E-mail: Peter.Mclarty_at_mincom.com
Technical Consultant WWW: http://www.mincom.com
APAC Technical Services Phone: +61 (0)7 3303 3461
Brisbane, Australia Mobile: +61 (0)402 094 238
Facsimile: +61 (0)7 3303 3048
=================================================
"If people did not sometimes do silly things, nothing intelligent would
ever
get done."
- Ludwig Wittgenstein
=================================================
Mincom "The People, The Experience, The Vision"
=================================================
This transmission is for the intended addressee only and is confidential
information. If you have received this transmission in error, please
delete it and notify the sender. The contents of this e-mail are the
opinion of the writer only and are not endorsed by the Mincom Group of
companies unless expressly stated otherwise.
"Tanel Poder" <tanel.poder.003_at_mail.ee>
Sent by: ml-errors_at_fatcity.com
28/12/2003 06:19 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
cc:
Subject: Re: TNSPING VS. REGULAR PING..! WHY SUCH A DIFFERENCE
I agree that this difference might be only because sqlnet is much more
"fat" that ICMP.
But anyway, could some overhead be added be because the failover & load
balancing clauses that require extra work?
Also, if listener logs every connection, this might add some extra IO time
as well (if writes for log file aren't write buffered).
Tanel.
----- Original Message -----
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, December 23, 2003 3:29 AM
I have recently noticed in this one situation that there is a great
difference between a tnsping vs a regular ping to the same server.
for example this tnsping took about 270 ms which is strange and its
consistent
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADD
RESS_LIST = (load_balance = on) (failover = on) (ADDRESS = (PROTOCOL =
TCP)(HOST
= myhost1.com)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST =
myhost2.com)(
PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = xyzdb) (FAILOVER_MODE =
(TYPE
= SELECT) (METHOD = BASIC) (RETRIES = 20) (DELAY = 15))))
OK (270 msec)
and a ping to the same host
Ping statistics for x.x.x.x:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 61ms, Maximum = 70ms, Average = 67ms
Why could there be such a difference?
Do you Yahoo!?
Yahoo! Photos - Get your photo on the big screen in Times Square
--
This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please notify the sender and delete the transmission. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: Peter.McLarty_at_mincom.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Sun Dec 28 2003 - 07:54:24 CST
