Print Thread
PL/SQL freeze on connection change
#61898 07/28/20 03:16 PM
Joined: Oct 2002
Posts: 59
Quebec,Canada
D
DLGL Offline OP
Member
OP Offline
Member
D
Joined: Oct 2002
Posts: 59
Quebec,Canada
Hi,

Using 14.01.11965 64 bits.

Unable to replicate this anytime...
You do a simple select on a table.
You change the master connection or the window connection to another DB.
Execute the SQL (F8) then it freezes. You must kill the application.
You restart and reconnect on target DB and all is ok.

I have a couple of users experiencing this.

Re: PL/SQL freeze on connection change
DLGL #61900 07/29/20 08:57 AM
Joined: Aug 1999
Posts: 22,208
Member
Offline
Member
Joined: Aug 1999
Posts: 22,208
To obtain some more diagnostic information, can you modify the PL/SQL Developer shortcut and add the DebugSQL parameter? For example:

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

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


Marco Kalter
Allround Automations
Re: PL/SQL freeze on connection change
Marco Kalter #61901 07/29/20 12:41 PM
Joined: Oct 2002
Posts: 59
Quebec,Canada
D
DLGL Offline OP
Member
OP Offline
Member
D
Joined: Oct 2002
Posts: 59
Quebec,Canada
Will do. Thanks

Re: PL/SQL freeze on connection change
DLGL #61970 08/26/20 12:40 PM
Joined: Jan 2015
Posts: 5
R
Member
Offline
Member
R
Joined: Jan 2015
Posts: 5
I have a similar issue (version 14.0.2). On connection change PLSQL Developer freezes for quite a while, after waiting I am able to use it again with the new connection.

I executed the following steps to reproduce it:

- Start PLSQL Developer
- Choose an environment to connect with
- Let PLSQL Developer connect
- Choose another environment to connect with
- See the application freeze and wait untill you can use the new connection. Sometimes it lasts more than 10 seconds.

Marco I send you a DM because I don't know how I can send you the debug log.

Last edited by Rens; 08/26/20 12:41 PM.
Re: PL/SQL freeze on connection change
DLGL #61971 08/26/20 01:11 PM
Joined: Aug 1999
Posts: 22,208
Member
Offline
Member
Joined: Aug 1999
Posts: 22,208
You can send it by email to support@allroundautomations.com, or add it as attachment to a forum reply.


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.082s Queries: 14 (0.027s) Memory: 2.5124 MB (Peak: 3.0380 MB) Data Comp: Off Server Time: 2024-05-03 10:59:37 UTC
Valid HTML 5 and Valid CSS