Re: tnsping problem

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

tnsping seems okay.. we have one 3840 msec there, but it gets normal in the subsequent iterations.

sqlnet message from client is not a active wait. It means client is not requesting anything from database.. So session is not doing anything, it is wating.. It is not a server side related wait.

Again..
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..(AWR analyis, ASH analysis, Problematic query- Execution plan analysis and son...)