PL/SQL Developer freeze

[yongming]

After some Microsoft security updates over the weekend, the PL/SQL Developer starts freeze when I type . in the select statement. From example for the intended select statement:
select t.clientname, t.tractiondate from mytest t;

After I type select t. the PL/SQL developer will freeze. Anybody has similar problem? or any solutions?

thanks,

yongming

 

[Marco Kalter]

The problem here is that PL/SQL Developer's Code Assistant tries to present a column list for a table but somehow this is very slow. Maybe it's an Oracle Net issue, or maybe one or more Oracle Dictionary views have a performance problem. To prevent this, you can go to the "Code Assistant" page of the preferences and disable the "Automatically activated" option. Now you need to explicitly activate the Code Assistant (by pressing F6) when needed.

You mentioned that this problem happens since last weekend, so it may be related to the database instance state. You might consider to shutdown and restart the instance to verify this.

 

[yongming]

This is not related to a particular instance. We can use TOAD and/or other SQL tools with no problem. This issue is very possible ralated to the microsoft security updates we did over the weekend. See the link for the miscrosoft updates.

http://www.microsoft.com/technet/security/current.aspx