PL/SQL Developer Hanging With Oracle 10g

[Ken B.]

When typing something like a simple SELECT statement in either the Command window or the SQL window, PL/SQL Developer will hang for several (sometimes 30) seconds mid-statement. This happens only with our 10g (most are 10.2.0.4.0) databases. We don't see this behavior when using PL/SQL Developer with our 9i databases. Nor do we see this behavior when using Oracle SQL Developer with our 10g databases. It seems to be specific to PL/SQL Developer and 10g.

We're using version 7.1.5.1398 on Windows XP Professional SP3.

Many thanks in advance.

 

[Worker]

Is this perhaps caused by the Code Assistant activating? Try going to Tools->Preferences->Code Assistant and un-checking "Automatically activated".

 

[Ken B.]

Worker, you win a new car and $5000. That solved the problem. It's just weird that we had the issue with 10g and not 9i.

Many thanks from the great State of Nevada!