CPU Usage Issue

[clock]

I'm currently running PLSQL Developer 12.0.6.1832 64bit on a windows 10 VM. I'm noticing at times, specifically when copying things from within PLSQL Developer to the clipboard, that the program tends to consumer 95% cpu and then hangs. It doesn't happen always, but it is isolated to PLSQL Developer. Any thoughts on what could be causing this issue?

 

[Marco Kalter]

I'm not sure what could be causing this. Is this reproducible for you?

 

[clock]

Yes, I'm experiencing the issue as we speak. The only thought I had was that possibly there's a built in plugin that may not be compatible with a new security software or scan running on my VM machine. Is there an PLSQL Developer application log or something that I could look at? Maybe even a debugger mode for the application itself?

 

[Marco Kalter]

To obtain some more diagnostic information, can you modify the 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).

 

[clock]

Here are a couple of excerpts from the logfile during the time that it happens. I'll get you a full log here soon:

00:06:47.878 EditCopy
00:06:47.879 ScreenActiveCustomForm EditCopy
00:06:47.879 ChildForm.EditCopy
00:06:47.879 TSyntaxMemo

 

[clock]

Unfortunately I don't see to have the ability to attach a file to this post. How would you like me to get this Debug file to you?

 

[clock]

I may have figured out my issue but time will tell. I noticed the following in the debug file today:

00:01:28.088 WebUpdate.URLDownload retry
00:01:28.089 WebUpdate.DownloadTextFile: URL=http://www.allroundautomations.com/update/pls.news
00:01:49.136 WebUpdate.URLDownload ends: False
00:01:49.136 WebUpdate.DownloadTextFile done

The VM this runs on does not have access to external sites. I went into preferences and turned off news checking so we'll see if this fixes the problem.

 

[Natalen]

thank you for information.

 

[clock]

I still seem to be having an issue on occasion. I really feel that my issue is related to a firewall timeout setting. Basically if my PLSQL instance times out and then I attempt to reuse it, it behaves abnormally even after I log back in. My Debug.txt log shows nothing for this session once it freezes, following the program timeout.

Is there a keep alive option that will basically send a packet across my current session, that or run a select 1 from dual periodically?

 

[Ivan C.]

A colleague of mine had a similar issue. He fixed it by disabling Clipboard History.

In Preferences click on Editor option under User Interface section.
In the right pane scroll down to the Clipboard section and uncheck Clipboard History.

 

[clock]

Thanks I'll give that a shot and respond to this thread on how it goes.

 

[vlevi]

Yesterday I've experienced the same problem.
Desktop PC, with i5-3470, 8GB RAM, no virtual macnine.
PL/SQL Developer 12.0.6 used 25% CPU (with is 100% on one core).
It was nearly unusable.