PL/SQL Developer All Objects View

[SteveL]

When I click on any of the object folders in All Objects (e.g tables functions etc) then the egg-timer displays but the folder fails to expand.

If I change to My Objects then the object folders expand OK

Any help would be most appreciated

 

[Marco Kalter]

The problem is caused by poor dictionary view performance. As a test, can you modify the PL/SQL Developer and add the QueryHints parameter? For example:

"C:\Program Files\PLSQL Developer\plsqldev.exe" QueryHints

This will apply a /*+rule*/ hint to this query, which can help.

 

[SteveL]

Thanks for your help Marco

Adding the parameter 'QueryHints' works so that I am able to view 'All Objects'

Is that the solution or is there anything I need to do to improve the dictionary view performance

 

[Marco Kalter]

As far as I know this is the only solution.

 

[SteveL]

Ok, thanks again Marco