PLSQL Developer app is freezing

[Lacek]

PLSQL developer is freezing if it goes to background and it is not used for 10-15 minutes. It has to kill from task manager and to restart. Everybody suffer from this in our company. Old version was perfect, with this new 12.x pain to work.

Please help or fix it. Current version is broken.
We tried to reinstall Win10, PL/SQL dev; to delete that registry section (position); to exec with all compatible mode; to run w/ admin; with different remote and local databases - the problem is real and constant.

PL/SQL Developer
Version 12.0.7.1837 (64 bit)
01.114389 - 5 user license
Service Contract: 2020. 07. 01.
Windows 10 Build 17134

Physical memory : 16 710 292 kB (8 759 720 available)
Paging file : 19 200 660 kB (7 806 064 available)
Virtual memory : 137 438 953 344 kB (137 434 268 280 available)

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

Preferences
Session mode: Dual
OCI Library:
Use OCI7: False
Allow Multiple Connections: True

Preference Files
C:\Users\Lacek\AppData\Roaming\PLSQL Developer 12\Preferences\default\Default.ini
C:\Users\Lacek\AppData\Roaming\PLSQL Developer 12\Preferences\Lacek\default.ini

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

Debug file
C:\Users\Lacek\AppData\Roaming\PLSQL Developer 12\PlSqlDev.elf

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

Aliases
EXTPROC_CONNECTION_DATA
FKF_NEW
GDAT
GDEV
GEOXE
...

Homes
OraClient12Home1 (C:\oracle\product\12.1.0\client_1)

DLLs
C:\oracle\product\12.1.0\client_1\bin\oci.dll

TNS File
C:\oracle\product\12.1.0\client_1\Network\Admin\tnsnames.ora

Using
Home: OraClient12Home1
DLL: C:\oracle\product\12.1.0\client_1\bin\oci.dll
OCI: version 12.1 (12.1.0.2.0)
Oracle Database 11g Release 11.2.0.4.0

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

Process
Working Set = 135 565 312
Memory = 47 053 096
GDI Objects = 576
User Objects = 341
Handles = 448

Monitors
PixelsPerInch = 96

Id = 0
Primary = True
Handle = 196609
Left = 0
Top = 0
Width = 2560
Height = 1440

Id = 1
Primary = False
Handle = 48501287
Left = 2560
Top = 360
Width = 1920
Height = 1080

MainFormOnTaskbar = False
---

Earlier I don't know about this forum.
I guess something Delphi component's (in PLSQL Dev) repaint event causes this.

 

[Marco Kalter]

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 12\plsqldev.exe" DebugSQL

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

 

[Lacek]

Hi Marco, thanks your help. I added DebugSQL param, I reproduced the problem and created debug.txt, I sent you the debug.txt in email.
Thanks again.

 

[Lacek]

Hi Marco, any progress?

I tried to turn off:
- display buffering
- single document
but changed nothing, after 15-20 mins if I (we) don't use the PLSQL dev, the next action will cause freezing.

We have different PC on different location, with different net connection, with 1 or 2 monitors 720p-2k.

 

[Lacek]

Hi Marco, any progress, any advice?

 

[Marco Kalter]

We don't have any clues yet. Can you go to Preferences > Oracle / Connection, enable the "Check connection" option, reproduce the issue again, and send a new debug.txt file?