tnsping problem

[Arsalan]

Hello sir,
have a nice day,

ORACLE 12C
windows 2012

My question is client complain about database is slow

I login remotly to db server and check tnsping some time it give result in 20 msec and some time it take long time



Please guide me

[ErmanArslansOracleBlog]

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..

[Arsalan]

Sir,
Here is the result of tnsping from my labtop and

please find the attached screen shot of DB query,

About Database performance issue the db was worked fine before this problem this problem occured in 2 days
--

C:\Windows>tnsping afgprod 10
TNS Ping Utility for 64-bit Windows: Version 12.1.0.2.0 - Production on 27-JAN-2021 13:05:58

Copyright (c) 1997, 2014, Oracle.  All rights reserved.

Used parameter files:
c:\app\arsalah\product\12.1.0\dbhome_1\network\admin\sqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.******)(PORT = 1544)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = afgprod)))
OK (20 msec)
OK (3840 msec)
OK (40 msec)
OK (0 msec)
OK (10 msec)
OK (20 msec)
OK (0 msec)
OK (0 msec)
OK (10 msec)
OK (20 msec)
===================

[ErmanArslansOracleBlog]

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...)