Help to understand what the problem is, tnsping response time from 7-20 seconds. what could it be ? and is it ok? how to cure it? thank.

  • This is absolutely not normal. Where are you and the server are relative to each other (on the same network, in different local networks, communication via the Internet, God forbid communication via satellite)? - Smithson
  • @Smithson I will say more, besides the fact that it is on the same subnet 10 meters from the server. But if you run tnsping on the server PC where the base itself is, the time decreases by a maximum of 1 second (ie, if on the server for 7 seconds, then on the local PC, it takes 8 seconds) and I don’t know where to dig - Ethernets
  • top on the server that shows? Maybe there is such a lack of RAM that the listener is lying in a swap? - Smithson
  • @Smithson is not spinning on Linux, but on win 2008 server r2 enterprice. And the choice of OS did not depend on me, RAM in order, the server is quite powerful and RAM = 16 GB - Ethernets
  • Taki RAM just enough? What does the task manager for load on RAM and swap show? - Smithson

1 answer 1

The solution to the problem was as follows - the log file listener.log overflows after clearing the response time is from 0-10 ms. Location of the file app \ Oracle \ diag \ tnslsnr \ name \ listener \ trace