do we need any tuning from database end to fix this
We are using connection pooling ...
TNS CONNECTIONS IS TAKING LOT OF TIME HOW CAN I FIX THIS PROBLEM .
is there anything that , we can tune at oracle database ?
C:\>tnsping 64.37.242.101 8
TNS Ping Utility for 32-bit Windows: Version 8.1.7.0.0 - Production on 01-MAR-2004 17:12:53
(c) Copyright 1997 Oracle Corporation. All rights reserved.
Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=64.37.242.101)(PORT=1521))
OK (70 msec)
OK (60 msec)
OK (3020 msec)
OK (20 msec)
OK (20 msec)
OK (20 msec)
OK (20 msec)
OK (20 msec)
C:\>ping 64.37.242.101
Pinging 64.37.242.133 with 32 bytes of data:
Reply from 64.37.242.101: bytes=32 time=10ms TTL=253
Reply from 64.37.242.101: bytes=32 time=30ms TTL=253
Reply from 64.37.242.101: bytes=32 time=10ms TTL=253
Reply from 64.37.242.101: bytes=32 time<10ms TTL=253