ideal tnsping stats
Hi All
What is the ideal tnsping rate for a db to perform well on remote dbs.
I have two dbs which are connected over 2 gb network when i draw the tnsping for them it is giving as below.
[oracle@sunnyvaledb ~]$ tnsping orcl 3
TNS Ping Utility for Linux: Version 10.2.0.4.0 - Production on 12-MAR-2010 06:03:16
Copyright (c) 1997, 2007, Oracle. All rights reserved.
Used parameter files:
/oracle/product/10.2.0.1/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = sunnyvaleldb)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))
OK (300 msec)
OK (263 msec)
OK (295 msec)
[oracle@sunnyvaledb ~]$
What is the ideal tnsping rate for a db to perform well on remote dbs.
I have two dbs which are connected over 2 gb network when i draw the tnsping for them it is giving as below.
[oracle@sunnyvaledb ~]$ tnsping orcl 3
TNS Ping Utility for Linux: Version 10.2.0.4.0 - Production on 12-MAR-2010 06:03:16
Copyright (c) 1997, 2007, Oracle. All rights reserved.
Used parameter files:
/oracle/product/10.2.0.1/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = sunnyvaleldb)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))
OK (300 msec)
OK (263 msec)
OK (295 msec)
[oracle@sunnyvaledb ~]$
0