Hi,

I am using PL/SQL Developer and every time I compiled something the CPU usage hits 100% and locks up my computer until the package has compiled.

I am running this program on Windows XP Pro SP3, 3.2ghz P4 and 1Gb Ram.

Does anyone else experience this, or has anyone found a way to stop this as it is rather irritating.

Nick

Is the Oracle Server running on this PC as well?

No it is a remote server that I am compiling on.

I've the same problem when batch compiling from within command window.
Then nearly 100% CPU is used and heavy networking.

If compiling one package direct from program window, this problem does not exists.

Compiletime for 1 package using command window is also a multiple of that using program window.

(plsd 8.0.2 and also 7.x.x on client winXP, server w2k8 ora10gR2)

Can you go to Edit > PL/SQL Beautifier Options and check if the "Before Compiling" option is enabled?

all Beautifier Options are unchecked

To obtain some more diagnostic information, can you modify the shortcut and add the debugsql parameter? For example:

"C:\Program Files\PLSQL Developer\plsqldev.exe" debugsql

Reproduce the problem and send me the debug.txt file that is generated in the PL/SQL Developer directory.

Hi Marco,

I've created debug logs for both scenarios (compile in program window took 2 sec. and compile from command window with @progfile; in about 2 min.). In addition I've a screen shut of task manager visualised the 100% CPU utilisation and the output of compiling time 1.6 sec (but waiting time was 2 min.).
What is the best way to send the ziped files to you?

thx fraenk

Just send them by e-mail.

Hello, is there something new with this issue? Or was it solved?