Print Thread
Page 1 of 3 1 2 3
PLSQL Developer freezes very often
#60249 07/01/19 09:59 AM
Joined: Jul 2019
Posts: 2
L
Member
OP Offline
Member
L
Joined: Jul 2019
Posts: 2
Hi,

So I have this problem for a long long time. Just now it got on my nerves and I decided to try and do something about it.

The PLSQL Developer Freezes a lot during the day. Each freeze lasts about 30 seconds to even 2 minutes.
The freeze seems unrelated to anything, It can be on query submission, on simply switching windows, on copying text, on invoking auto complete, on starting up explain plan, on clicking any button really. it seems to happen on random events sometimes unrelated to network, querying, CPU or anything.
Video example of a freeze during explain plan startup

And its not that the DB is slow, the plan takes time or anything. if I use Toad for example that plan would take 2 seconds to come back.

Can this problem be solved?

thank you!

Re: PLSQL Developer freezes very often
LucciCap #60250 07/01/19 12:06 PM
Joined: Aug 1999
Posts: 22,173
Member
Offline
Member
Joined: Aug 1999
Posts: 22,173
I see that this happened in the video when opening a new Report Window. The Report Window has appeared, but it is not yet displayed in the Window List.

Can you go to Help > Support Info and send me the information from the "Info" tab page by e-mail? We can then send you instructions to obtain more diagnostic information.


Marco Kalter
Allround Automations
Re: PLSQL Developer freezes very often
Marco Kalter #60255 07/02/19 08:36 AM
Joined: Jul 2019
Posts: 2
L
Member
OP Offline
Member
L
Joined: Jul 2019
Posts: 2
Thank you Marco,
I have sent you the File to 'support@allroundautomations.com'

Re: PLSQL Developer freezes very often
LucciCap #60257 07/02/19 09:28 AM
Joined: Aug 1999
Posts: 22,173
Member
Offline
Member
Joined: Aug 1999
Posts: 22,173
Thanks. I have sent you a reply for further diagnostics.


Marco Kalter
Allround Automations
Re: PLSQL Developer freezes very often
LucciCap #63942 05/18/22 05:53 PM
Joined: Nov 2021
Posts: 1
P
Member
Offline
Member
P
Joined: Nov 2021
Posts: 1
Was there any fix to this? I am having the same trouble. here's my info page:

Quote
PL/SQL Developer
Version 13.0.6.1911 (64 bit)
01.120068 - Unlimited user license
Service Contract: 2019-07-01
Windows 10 Build 19041

Physical memory : 16,514,264 kB (4,677,700 available)
Paging file : 35,388,632 kB (21,491,696 available)
Virtual memory : 137,438,953,344 kB (137,434,182,804 available)

Parameters
C:\Program Files\PLSQL Developer 13\plsqldev.exe

Preferences
Session mode: Multi
OCI Library: <none>
Use OCI7: False
Allow Multiple Connections: True

Preference Files
C:\Users\G520844\AppData\Roaming\PLSQL Developer 13\Preferences\default\Default.ini
C:\Users\G520844\AppData\Roaming\PLSQL Developer 13\Preferences\G520844\default.ini

License File
C:\ProgramData\PLSQL Developer\aalf.dat

Debug file
C:\Users\G520844\AppData\Roaming\PLSQL Developer 13\PlSqlDev.elf

Plug-Ins
*Active Query Builder (C:\Program Files\PLSQL Developer 13\PlugIns\ActiveQueryBuilder.dll)
*PL/SQL Documentation (plsqldoc) (C:\Program Files\PLSQL Developer 13\PlugIns\plsqldoc.dll)
(* is Active)

Aliases
ACTVREC_MGO_D
ACTVREC_MGO_P
APOR_MGO_D
APOR_MGO_P
APOR_MGO_Q
...

Homes
oracle_64_12c (C:\Oracle\product\instantclient_12.1.0.2.0_64\)
OraClient11g_home1 (C:\Oracle\product\11.2.0_64\client_1)

DLLs
C:\Oracle\product\instantclient_12.1.0.2.0_64\oci.dll

TNS File
C:\Oracle\tnsnames\tnsnames.ora

Using
Home: oracle_64_12c
DLL: C:\Oracle\product\instantclient_12.1.0.2.0_64\oci.dll
OCI: version 12.1 (12.1.0.2.0)
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0

Character Sets
Character size: 4 byte(s)
CharSetID: 873
NCharSetID: 2000
Unicode Support: True
NLS_LANG: AMERICAN_AMERICA.WE8MSWIN1252
NLS_NCHAR_CHARACTERSET: AL16UTF16
NLS_CHARACTERSET: AL32UTF8

Process
Working Set = 128,712,704
Memory = 31,614,408
GDI Objects = 1606
User Objects = 567
Handles = 806

Monitor
PixelsPerInch = 96

Id = 0
PPI = 96
Primary = True
Handle = 593095
Left = 0
Top = 0
Width = 3840
Height = 2160

MainFormOnTaskbar = True

Re: PLSQL Developer freezes very often
LucciCap #63943 05/19/22 08:39 AM
Joined: Aug 1999
Posts: 22,173
Member
Offline
Member
Joined: Aug 1999
Posts: 22,173
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 13\plsqldev.exe" DebugSQL

Reproduce the problem and send me the debug.txt file that is generated in directory "C:\Users\G520844\AppData\Roaming\PLSQL Developer 13".


Marco Kalter
Allround Automations
Re: PLSQL Developer freezes very often
LucciCap #63944 05/20/22 11:07 AM
Joined: Oct 2018
Posts: 25
M
Member
Offline
Member
M
Joined: Oct 2018
Posts: 25
I have a bit different problem.
1. When the PLSQL Developer Freezes It freezes also the whole desktop. I'm unable to click on any other program. When ver. 14 was freezing (due to recompiling many objects on base) then I could switch to another program. Now the whole Windows freeze. Looks like ver 15 is more connected with widows.
2. When I minimize and then maximize the PLSQL Dev it first shows black widows, then it begines to slowly refresh widows. It takes from 2 seconds to 10 seconds. Looks like that the longer it is PLSQL Dev out of focus the longer it takes to reassembe it. My computer is a few years old but quite strong, it should work better.

Re: PLSQL Developer freezes very often
LucciCap #64002 06/15/22 07:23 PM
Joined: Oct 2002
Posts: 59
Quebec,Canada
D
Member
Offline
Member
D
Joined: Oct 2002
Posts: 59
Quebec,Canada
I experience point 2. of @matejj everytime PSD is minimized. The redraw of PSD when maximized takes couple of seconds showing black ribbon and SQL zone.

Re: PLSQL Developer freezes very often
LucciCap #64011 06/19/22 06:37 PM
Joined: Jun 2015
Posts: 72
Russia
L
Member
Offline
Member
L
Joined: Jun 2015
Posts: 72
Russia
My colleague reported freezes in PLSD. We tried to remove git directories in "Files" tab and freezes are gone. Maybe it helps.

Re: PLSQL Developer freezes very often
LucciCap #64014 06/21/22 12:14 AM
Joined: Jan 2003
Posts: 88
A
Member
Offline
Member
A
Joined: Jan 2003
Posts: 88
Similar hangs here, but *not* using version control in PSD.

Page goes grey and Windows sometimes asks if want to kill or wait for it to complete.

We also occasionally lose icons and names in the left-hand panels e.g Files. We can still see the folder structure, but the item icon and file name is missing. This usually proceeds a crash from PSD that generates a support email and then it gets into a loop of crashing and emailing.


Andy
Page 1 of 3 1 2 3

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.025s Queries: 16 (0.006s) Memory: 2.5667 MB (Peak: 3.0377 MB) Data Comp: Off Server Time: 2024-03-28 12:27:15 UTC
Valid HTML 5 and Valid CSS