Re: tnsping problem

Posted by ErmanArslansOracleBlog on Jan 27, 2021; 7:28am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/tnsping-problem-tp9275p9277.html

tnsping doesn't check the database.. It only reaches the listener..
If your clients feel that the database is slow, you need to make more comprehensive analysis..
You need to check performance of the database and OS(and so on..) also..

But!When checking your connection with tnsping, I recommend you to check it for 5-6 iterations..

example for 5 iterations: tnsping PROD_DB 5
First tns ping may take some time, but the subsequent tnspings will probably take less time..

the speed of tnsping is dependent on several things bytheway.. Your client performance/load, the latency between your dns and your client, your network and so on...

But, as I mentioned, you need to make a more compresenhive analysis.
Also, this may not be general/ db-wide performance problem. Speak with your client, understand what they mean by slowness.. Check your db, check the things according to the input that your client's will give to you.
Independent of what your clients say, still, do a general performance analysis..