Print Thread
PLSQL Devleoper hangs up
#64269 10/11/22 11:29 AM
Joined: Nov 2021
Posts: 5
I
ITTCT Offline OP
Member
OP Offline
Member
I
Joined: Nov 2021
Posts: 5
Hi,

I have some problem with the new version of the developer.
When I run a select with many rows and I try to scroll down (still fetching rows) the developer freezes and I cannot stop the execution, also when the rows are fetched and I resize the window the same happens.

The other thing is when I highlight or copy/cut some text from sql/program window then it hangs up for a couple of seconds, after this everything works fine.

Developer version:
PLSQL Developer 15.0.2
WIN 10

Thanks for your help.

Best regards,
ITTCT

Last edited by ITTCT; 10/11/22 11:30 AM.
Re: PLSQL Devleoper hangs up
ITTCT #64271 10/12/22 08:52 AM
Joined: Aug 1999
Posts: 22,204
Member
Offline
Member
Joined: Aug 1999
Posts: 22,204
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 15\plsqldev.exe" DebugSQL

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


Marco Kalter
Allround Automations
Re: PLSQL Devleoper hangs up
ITTCT #64325 11/11/22 08:15 PM
Joined: Nov 2022
Posts: 1
M
Member
Offline
Member
M
Joined: Nov 2022
Posts: 1
This problem (or similar) also occurs on PLSQL developer 14.
One simple way to reproduce the similar problem (on plsql 14 or 15):
1 - Start executing a very slow query (that will take some minutes to start returning data);
2 - Previous than the results arrive, click on the panel where the query results should appear;
3 - Verify that PLSQL hang!

Thanks,
MAOR

Re: PLSQL Devleoper hangs up
Marco Kalter #64377 01/11/23 02:54 PM
Joined: Nov 2021
Posts: 5
I
ITTCT Offline OP
Member
OP Offline
Member
I
Joined: Nov 2021
Posts: 5
Hi Marco,

Sorry for the late reply, here is the debug file.

Thanks for your help.
ITTCT

Attached Files
Debug.txt (422.39 KB, 4 downloads)
SHA1: e8d13236db96f0c59e21e0f36689e666039e8c8a

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.255s Queries: 16 (0.121s) Memory: 2.5086 MB (Peak: 3.0378 MB) Data Comp: Off Server Time: 2024-04-25 20:05:54 UTC
Valid HTML 5 and Valid CSS