Murali Vallath <[EMAIL PROTECTED]> wrote: 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? =================================================== more layers in the OSI stack, longer code path. try passing the argument (# of attempts) to tnsping to see if its consistently high, e.g.: D:\Oracle\Ora92\bin>tnsping mydb 5 TNS Ping Utility for 32-bit Windows: Version 9.2.0.4.0 - Production on 22-DEC-20 03 23:03:38 Copyright (c) 1997 Oracle Corporation. All rights reserved. Used parameter files: D:\Oracle\Ora92\network\admin\sqlnet.ora Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = badmofo)(PORT = 1551))) (CONNECT_DATA = (SERVICE_NAME = mydb.mydomain.com))) OK (110 msec) OK (30 msec) OK (10 msec) OK (20 msec) OK (10 msec) Pd __________________________________ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Drake INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
