PL/SQL freezes when clicking in the results window

[Luis]

Hi

Pl/SQL developer 7.0.3.1123, Oracle 9.2.0.8

I execute a query like "select * from my table". The results are displayed in the result grid. When I click in the result grid, PL/SQL developer freezes for a few seconds. It seems that it is busy doing something. But my query has run already, I just clicked in the result grid...

Though it is not a big problem, can be frustrating sometimes as I run dozens of queries during the day.

There are a few other situations where it freezes for a while as well, for instance when I press F6 to get the list of columns from a table alias (it can take sometimes as long as 10 secs), or when I reconnect. The thing is -- I have used PL/SQL developer a lot in previous jobs and never had this problems before.

Is there something can be done to improve this?

Thanks
Luis

 

[Joachim Rupik]

Uncheck in Preferences / Window Types / SQL Window a "Show dictionary info in result grid" preference.

 

[Luis]

Hi

Thanks for the tip; it worked!

However, it is an workaround -- what if I wanted to see the dictionary info for instance? As I said I used PL/SQL Developer in other environments (with that flag on) and never had this type of problem. It seems then that the access to the data dictionary is a bit slow here (and is affecting other actions too)... is there anything that I can do to improve this?

Thanks
Luis

 

[Marco Kalter]

It indicates a performance problem with dictionary views like all_tables, all_tab_columns, all_synonyms, ....