Good god!
I three machines in the oracle client to use pl/SQL remote connect to the database, in which two is an ordinary PC, a server is installed Windows server2008, remote access to the database connection and query is very slow, a select statement to 1 minute;
The third is your laptop, Windows 7, the same query as long as one second, really don't know is what reason, give advice or comments please everyone a great god!!

CodePudding user response:

See how fast the tnsping server

CodePudding user response:

reference 1st floor ghx287524027 response:

tnsping server and see how fast

TNS Ping Utility for 32 - bit Windows: Version 10.2.0.1.0 - Production on September 19 - -
2016 16:42:42

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

Have used the parameters of the file:
E: \ oracle \ product \ 10.2.0 \ client_1 \ network \ admin \ sqlnet ora

Already use EZCONNECT adapter to parse the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=https://bbs.csdn.net/topics/SERVICE_NAME=(former)) (ADDRESS=(P
ROTOCOL=TCP) (HOST=192.168.1.28) (1521) PORT=))
OK (20 milliseconds)

This is the result of a very slow tnsping that machine

CodePudding user response:

In addition, check your PC's network configuration information for IP, mask, gateway, DNS, etc., can be connected, is whether it is reasonable and unreasonable but will slow, gateway, mask, DNS can be consistent with the laptop

CodePudding user response:

reference ghx287524027 reply: 3/f

in addition, check your PC's network configuration information for IP, mask, gateway, DNS, etc., can be connected, is whether it is reasonable and unreasonable but will slow, gateway, mask, DNS can be consistent with the laptop

IP, mask, gateway, DNS is consistent with the laptop, I changed the IP address like notebook tried, or slow

CodePudding user response:

Qq look at 212646490