Is TNSPING = 1000ms OK? Oracle says it is
- From: Tony Jambu <tjambu_freelists@xxxxxxxxxxxx>
- To: Oracle-L@xxxxxxxxxxxxx
- Date: Tue, 07 Mar 2006 23:55:20 +1100
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)
Other related posts:
