Print Thread
Slow reconnect
#54083 09/30/16 07:10 AM
Joined: Sep 2008
Posts: 34
C
Member
OP Offline
Member
C
Joined: Sep 2008
Posts: 34
When plsql developer is "resumed" after changing LAN settings, it takes extremely long time to "activate" developer. It freezes for 30 sec (or minutes sometimes...)

Its very uncomfortable when :
- I use various VPN during my wok, when I disconnect VPN, I have to wait for developer to "wake-up" to refresh local oracle connection.

- I left PC with (connected) developer, then PC hibernates, and when I come back to PC, {C resumes fast, but I have to wait for developer to "wake up". Its no reason for this behavior.


Edit: Just for clarification:
when this situation occurs (plsql "hangs" doing something) I'm able to start new instance of Plsqldeveloper, which connect to the same oracle connection very fast and I'm able to work with this instace (the first original instance is still "doing something", UI is freezed)

Last edited by czdavidm; 09/30/16 08:22 AM.
Re: Slow reconnect
czdavidm #54112 10/07/16 07:35 AM
Joined: Nov 2013
Posts: 22
Independent developer, Sloveni...
U
Member
Offline
Member
U
Joined: Nov 2013
Posts: 22
Independent developer, Sloveni...
I have the same observations. And yes it is annoying.

Re: Slow reconnect
uros.r.d #54114 10/07/16 08:57 AM
Joined: Aug 1999
Posts: 22,221
Member
Offline
Member
Joined: Aug 1999
Posts: 22,221
Can you check if this is resolved with the 64 bit version?


Marco Kalter
Allround Automations
Re: Slow reconnect
Marco Kalter #54115 10/09/16 05:40 AM
Joined: Feb 2013
Posts: 46
P
Member
Offline
Member
P
Joined: Feb 2013
Posts: 46
Yes, it's the same for 64bit. And the problem occures even without switching VPN or any network settings. It is only occurred when a VPN connection is used.
Just open Developer, use to make some calls etc and then leave it for an hour. When you come back it "freezes". If you have open windows for several DB connections, then it freezes each time you open a window with new DB connection that hasn't freezes already. I mean 3 windows with 3 DBs will lead to 3 consequential freezes for 30 seconds.


Pavel Kaplya
Re: Slow reconnect
Pazus #54116 10/10/16 09:48 AM
Joined: Aug 1999
Posts: 22,221
Member
Offline
Member
Joined: Aug 1999
Posts: 22,221
To obtain some more diagnostic information, can you modify the shortcut and add the DebugSQL parameter? For example:

"C:\Program Files\PLSQL Developer\plsqldev.exe" DebugSQL

Reproduce the problem and send me the debug.txt file that is generated in the PL/SQL Developer directory or in the %APPDATA%\PLSQL Developer directory (e.g. C:\Users\<User>\AppData\Roaming\PLSQL Developer).


Marco Kalter
Allround Automations
Re: Slow reconnect
czdavidm #59058 11/27/18 08:38 AM
Joined: Oct 2015
Posts: 1
D
Member
Offline
Member
D
Joined: Oct 2015
Posts: 1
Was this cause of this problem ever identified? I am suffering with it too.

Re: Slow reconnect
David Ainsley #59067 11/27/18 11:15 AM
Joined: Aug 1999
Posts: 22,221
Member
Offline
Member
Joined: Aug 1999
Posts: 22,221
It's usually a client configuration issue. Can you go to Help > Support Info and send me the text from the "Info" tab page?


Marco Kalter
Allround Automations

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.037s Queries: 15 (0.009s) Memory: 2.5222 MB (Peak: 3.0394 MB) Data Comp: Off Server Time: 2024-05-21 06:42:23 UTC
Valid HTML 5 and Valid CSS