10g weirdness

[Sunil Rao]

Hello All,
I am using PL/SQL Developer version 6.0.6.946, Oracle client 8.1.7 and Oracle server 10.1.0.2.0.
This was working before but
since a couple of days, after logging into PL/SQL Developer, when I try to open the any of the folders on the left menu, PL/SQL Developer hangs up.
The only folder on the left menu that works is the tablespaces folder. I can navigate my way from there to query and edit the tables, but I cannot use any other menu option. Any help would be really appreciated. Let me know if anything is not clear in my message.

Thanks,
Sunil

 

[Marco Kalter]

Perhaps you can check your default Browser Filter to verify that the where clause and order by clause do not cause performance problems? These filter properties fo not apply to the Tablespaces folder, so that might explain the difference.

You can query the all_objects view with the where clause and order by clause to verify performance.