PL/SQL Dev hangs when using object browser

Hi,

Whenever I try to expand the "tables" root in the object browser PL/SQL dev hangs for a minute or two.

It is *extremely* annoying.

Anyone know how to fix this?

Fred
 
One option to try is to use the browser filters if you mostly care about a few types of tables.

For example, most of the time, I only care about custom packages and tables. All of our custom stuff starts with 'Z', so I created a filter called custom and added "object name like 'Z%'. I have that as my default filter. I created another filter for HR/Benefit objects (object name like '%BEN% or object name like '%HR%' etc.) since that's the application I work on. Then I just choose the filter that I need. The response time for me went from about a minute getting all packages to a few seconds using filters.

Another option to look into is to work with your DBA's and try to make the SQL getting the data run faster. I haven't tried this though since the filters work fine for me.

Mike
 
Back
Top