PL/SQL Freezes when accessing Dictionary

[Larsen]

Hello,

I got a problem with PLSQL Developer Version 5.0.2.500, with Oracle 8i 8.1.7.4.0, from the last week to now.
When accessing the dict, the PLSQL freezes.
An example:
"select * from table_name a where a."
When I write the ".", the window freezes, hanging lots of PLSQL (we work with Citrix Metaframe).

But what call ours attention is that it's happening only with one of ours database. If I'm connected in one database, and then logout and logon at the problematic database, this happens.

So, my doubt is with there is anything that PLSQL needs from the database, to read the Dict? Any public synonym or privilege?

Thanks for any help.

Best Regards,

Larsen

 

[Marco Kalter]

PL/SQL Developer attempts to describe the table, and apparently this takes a long time on this specific database. This indicates a performance problem with one or more dictionary views. It could be the all_synonyms, all_objects, all_tables, or all_tab_columns view.