Print Thread
FAQ: Slow performance when logging on or executing a SQL Window or Test Window
#10151 01/28/03 11:50 PM
Joined: Sep 1999
Posts: 21
F
faq Offline OP
Member
OP Offline
Member
F
Joined: Sep 1999
Posts: 21
A logon in PL/SQL Developer takes a very long time. When I subsequently execute a SQL Window or Text Window, this also causes a huge delay.

Re: FAQ: Slow performance when logging on or executing a SQL Window or Test Window
#10152 01/28/03 11:56 PM
Joined: Sep 1999
Posts: 22
S
Administrator
Offline
Administrator
S
Joined: Sep 1999
Posts: 22
This seems like a connection problem. Each SQL Window and Test Window uses its own session, and therefore needs to connect when executed for the first time. You should check this file:

%OracleHome%\Network\Admin\sqlnet.ora

If it contains this line:

SQLNET.AUTHENTICATION_SERVICES=(NTS)

Change it to a comment line:

# SQLNET.AUTHENTICATION_SERVICES=(NTS)

This is a known Oracle Installer bug that can cause unacceptable connection delays.


Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.069s Queries: 14 (0.017s) Memory: 2.4941 MB (Peak: 3.0378 MB) Data Comp: Off Server Time: 2024-04-24 15:46:31 UTC
Valid HTML 5 and Valid CSS