Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Is TNSPING = 1000ms OK? Oracle says it is

Is TNSPING = 1000ms OK? Oracle says it is

From: Tony Jambu <tjambu_freelists_at_yahoo.com.au>
Date: Tue, 07 Mar 2006 23:55:20 +1100
Message-Id: <7.0.1.0.2.20060307233757.051df5f8@wizard.cx>


Hi

I have a server (Windows Server ) with Oracle EE with databases using Data Guard. (Oracle 9iR2)

There is an Oracle Listener (1521) and Oracle Data Guard Listener (1748) on a server.

If I TNSPING both ports, I get the following results.

Port Response Time
---- --------------
1521 20 ms
1748 1000 ms

So I asked Oracle support and the reply -

The Data Guard needs to do lots of stuff and 1000 ms is OK.

What? That is x50 slower than a normal tnsping to 1521 and they tell me that this is acceptable?

What do you think?
What times do you get for tnspinging a Data Guard port? (The are no network QoS/packet shaping ) Even doing a loopback tnsping on the same server gives the same result.

Here are the outputs:

tnsping (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = server1dr)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = DRTEST.world))) 5  

TNS Ping Utility for 32-bit Windows: Version 9.2.0.7.0 - Production on 23-FEB-2006 14:46:41  

Copyright (c) 1997 Oracle Corporation. All rights reserved.

Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = server1dr)(PORT = 1521))))

OK (70 msec)
OK (20 msec)
OK (20 msec)
OK (10 msec)
OK (20 msec)
 



tnsping (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = server1dr)(PORT = 1748)))) 5  

TNS Ping Utility for 32-bit Windows: Version 9.2.0.7.0 - Production on 23-FEB-2006 14:46:49  

Copyright (c) 1997 Oracle Corporation. All rights reserved.  

Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = server1dr)(PORT = 1748))))

OK (440 msec)
OK (1000 msec)
OK (1000 msec)
OK (1000 msec)
OK (1000 msec)



--
http://www.freelists.org/webpage/oracle-l
Received on Tue Mar 07 2006 - 06:55:20 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US