Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Regarding TNSPING

user1740402Sep 29 2013 — edited Sep 29 2013

I am also having TNSPING response time issues.

We have intermittent times when it goes from 0-20 msecs to 10000+ msecs and back to 0-20 range.  I checked the DNS lookup portion, and it is consistently under 1 second.  So what is making the TNS listener take more than 10 seconds to respond?

The database is a single node, so there isn't a clustering issue, and the server itself isn't that busy (or resource bound).

I notice the same behavior on many different databases, all are 11gr2.  Some are clustered, some are not.  We've done extensive packet analysis, and determined that the latency is with the TNS listener or DB.  Any ideas?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 27 2013
Added on Sep 29 2013
2 comments
734 views