How to solve the problem that PLSQL connects to the server and executes SQL statements very slowly?

This article focuses on "how to solve the problem of PLSQL connecting to the server and executing SQL statements very slowly". Interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Let the editor take you to learn "how to solve the problem that PLSQL connects to the server and executes SQL statements very slowly".

PLSQL is very slow to connect to the server database

It takes several seconds to execute the SQL, but the second execution is fast. The provenance is found, and it is finally found that it is because of the problem of TNS.

[root@localhost ~] # cat / etc/resolv.conf

Search bj

Nameserver 202.101.224.68

The second record 2021.101.224.68 is a public network IP, and ping is not available on the server, so it takes a lot of time to connect and time out each login.

Delete the second record, connect in seconds, and finally solve it!

At this point, I believe you have a deeper understanding of "how to solve the problem of PLSQL connecting to the server and executing SQL statements very slowly". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!